Excel/Expert Profile

Average Ratings

• Knowledgeability 9.92
• Clarity of Response 9.86
• Timeliness 9.93
• Politeness 9.91

• Number of Questions (in Past 24 Hours) 1
• Max Questions to be Asked (in 24 Hour Period) 3
• Total Questions (since joining AllExperts) 2478
• Volunteer Since 2006-08-04
• Prestige Points 20020

Recent Reviews from Users

Read More Comments

Recent Answers from Stuart Resnick

2009-11-20 delete macros in a copy file:

The following code should be entered onto the VBE ThisWorkbook object. Then, whenever a Save As is done on the file, all vba modules will be deleted in the file that results from the save-as. Private

2009-11-20 Excel Macro:

Sub sample() Dim nRow As Long Dim MaxRow As Long Dim Ws As Worksheet Set Ws = Sheets("Sheet1") MaxRow = Ws.Range("a1").SpecialCells(xlCellTypeLastCell).Row For nRow = MaxRow

2009-11-19 VBA Code for Hyperlinks:

Look at the first 3 lines of your code: With Worksheets(1) set r = .Range("A3", .Range("A3").end(xlDown)) End With This sets the variable r to the range that begins with cell A3, and ends

2009-11-19 question about excel formula:

Example: in B2:B200 you have numbers. You want conditional formatting applied to this range, such that whenever there are 10 consecutive values in the range that are >23, all will have red font. Cell

2009-11-18 Countifs non-null values:

Example: you want a count of how many cells in Actu!$A$5:$A$127 are equal to 'Q on Q'!$B40... but you only want to count the cells for which the corresponding cell in Actu!$I$5:$I$127 is non-blank. The