| Home |
| Search |
| Today's Posts |
|
#5
|
|||
|
|||
Excel Macros
Hadn't spotted that one Bob<g
Regards Roger Govier Bob Phillips wrote: Thanks Roger, but there is a also a logic error. Should be Dim iLastRow as Long iLastRow = Cells(Rows.Count,"A").End(xlUp).Row If iLastRow = 1 And Cells(iLastRow,"A").Value = "" Then 'do nothing Else iLastRow = iLastRow + 1 End If Cells(iLastRow,"A").Value = Format(Date,"dd mmm yyyy") |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| Help for old macros with Excel 2002 | Excel Worksheet Functions | |||
| I deleted all macros in Excel but still get dialog box | Excel Discussion (Misc queries) | |||
| Are macros created in Excel 2003 compatible with Excel 5.0/95? | Excel Discussion (Misc queries) | |||
| How do I update Excel 2000 macros to work in Excel 2002? | Excel Discussion (Misc queries) | |||
Threaded Mode
