finding the first blank cell and then executing rest of macro

  • Thread starter Thread starter Ed
  • Start date Start date
E

Ed

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.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need Macro... 8
VBA code to find first blank cell in a column and activate it 4
Select next blank cell in column, before running macro 2
copy_paste to the first blank row 4
Blank cells problem 5
Macro: insert rows anywhere in the sheet 4
Insert row after blank cell encountered 6
Macro to Combine Data from Multiple Sheets with Cell References 4

Back
Top