Macro
Posted by Joe on January 22, 2001 11:32 AM
How to import text to an existing worksheet into the next available row with the use of a macro. How it stands now, is when running the macro, it imports the text into A1 over and over moving previous text to the right.
Posted by Dave Hawley on January 22, 2001 10:42 PM
Hi Joe
To find the last cell in a Column use:
[A65536].End(Xlup).cells(2,1)
To find the first blank cell use:
[A1].end(xldown).Cells(2,1)
Hope this helps
Dave
OzGrid Business Applications
