Print on worksheet

[Guest]

Hi! I have a simple problem. I want to print a certain value in on a
worksheet in a loop. For each loop I want to print on one cell below the
previous one. However there is something wrong with the line below, it does
not write anything on the worksheet. pls help!


Worksheets("Settings").Range("a1").Offset(1, k) = strDate

 

[Zone]

You could put this line in before your line to see which cell you're
addressing:
msgbox Worksheets("Settings").Range("a1").Offset(1, k).address
And you could add this line to see what strDate is:
msgbox strDate
Or, to see the date formatted as a date,
msgbox format(strdate,"mm/dd/yy")
James

 

[Mike Fogleman]

Add .Value
Worksheets("Settings").Range("a1").Offset(1, k).Value = strDate

see if that works

Mike F