| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro Help
Whatever "1row" is it is not part of Excel or VB. It looks like a variable
someone created in his code. Anyway, a typical way to find the next empty cell in a column is something like this: Set NextCell = Range("A65536").End(xlUp).Offset(1) for column A. This assumes the column is not full and there is at least one entry already there. -- Jim Rech Excel MVP |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro recorded... tabs & file names changed, macro hangs | Excel Worksheet Functions | |||
| need help to update macro to office 2007 macro enabled workbook | Excel Discussion (Misc queries) | |||
| Macro Help Needed - Excel 2007 - Print Macro with Auto Sort | Excel Worksheet Functions | |||
| My excel macro recorder no longer shows up when recording macro | Excel Discussion (Misc queries) | |||
| using a cell value to control a counter inside a macro and displaying macro value | Excel Worksheet Functions | |||
Threaded Mode
