Macro Question
Does anyone know the VBA code where for a range of date you want to program
the macro to go to the next empty column or row? -- EVZ |
Macro Question
hi,
From the end of row or column , use ' end ' fucntion to get the last filled cell and use offset to get the next cell like this one: by row sub test() range("A65536").end(xlup).offset(1,0)="Test" end sub try to run it several times.. to get the result... -- Regards, Halim "Ed" wrote: Does anyone know the VBA code where for a range of date you want to program the macro to go to the next empty column or row? -- EVZ |
All times are GMT +1. The time now is 12:15 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com