Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
finding the first blank cell and then executing rest of macro
Hi
I have a macro that extracts data from Outlook and inserts it into an excel worksheet. Please can somebody tell me what to put in the macro so that it looks for the first blank row and then adds the data? In other words, appends the new data at the end of the existing rows. If I need to provide more information, please let me know. Many thanks in advance. Annette. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
finding the first blank cell and then executing rest of macro
Annette, something like this, will select the next row down in column A
Range("A65536").End(xlUp).Offset(1, 0).Select -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Ed" wrote in message om... Hi I have a macro that extracts data from Outlook and inserts it into an excel worksheet. Please can somebody tell me what to put in the macro so that it looks for the first blank row and then adds the data? In other words, appends the new data at the end of the existing rows. If I need to provide more information, please let me know. Many thanks in advance. Annette. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Finding data and executing an action | Excel Discussion (Misc queries) | |||
FINDING AN EXACT MATCH ON 2 DIFFERENT SHEETS THEN EXECUTING A FORM | Excel Worksheet Functions | |||
Finding Next Blank Cell in Blank Row | Excel Worksheet Functions | |||
Executing a macro from a cell | Excel Discussion (Misc queries) | |||
executing a macro from within a cell | Excel Programming |