Excel/Expert Profile

Stuart Resnick

On Vacation
returns 12/01/2009
Expertise

I can answer any question relating to MS Excel formulas, or to programming with vba (Visual Basic for Applications) in the Excel environment

Experience in the area

As a consultant, I've designed Excel tools since the 90s, working for the Federal Reserve Bank, AT&T, and (currently) Gap Inc.

Average Ratings

Recent Reviews from Users

Read More Comments

    K = Knowledgeability    C = Clarity of Response    T = Timeliness    P = Politeness
UserDateKCTPComments
marcia11/21/0910101010works perfectly - many thanks i would .....
Richard11/19/0910101010Dear Mr. Resnick, Your solution worked perfectly .....
aj11/18/0910101010Thankyou... Got it myself in the end .....
hazim11/18/0910101010Once again great response time with the .....
Robin11/17/0910101010Stuart, Although the strategy was great it .....

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

 

Ask A Question

About Excel
This topic answers questions related to Microsoft Excel spreadsheet (or workbook) stand-alone or Mircrosoft Office Excel including Excel 2003, Excel 2007, Office 2000, and Office XP. You can get Excel help on Excel formulas(or functions), Excell macros, charting in Excel, advanced features, and the general use of Excel. This does not provide a general Excel tutorial nor the basics of using a spreadsheet. It provides specific answers to using Microsoft Excel only. If you do not see your Excel question answered in this area then please ask an Excel question here

All Answers

Answers by Expert:


Ask Experts

Volunteer


©2009 About.com, a part of The New York Times Company. All rights reserved.