Please Help - NumberFormat

[reneuend]

I'm getting an application-defined or object-defined error when using the following code. I could have sworn this worked before.

'Format TimeStamp Column
    sRange2 = "H2:H" & nLastRow
    ActiveWorkbook.Worksheets(INPUT2_TAB).Range(sRange2).NumberFormat = "m/d/yyyy"

note: INPUT2_TAB is a global constant for the worksheet name.


thanks for any suggestions.

 

[reneuend]

OH Good Grief!!!! I found it. nLastRow is coming back as "0", so the range is bad.

Sorry!