About Us

Graham[_3_]

I need a quick bit of code please. If I have data in
Columns A:I which I wish to keep adding to via macro;what
would be the code to find the next blank row and make it
the active row ready to receive the next batch of pasted
data.

Help much appreciated.
Thanks
Graham

Mike[_31_]

This will select the next available cell in column A.

Range("A" & Range("A65536").End(xlUp).Rows+1).Select

-----Original Message-----
I need a quick bit of code please. If I have data in
Columns A:I which I wish to keep adding to via macro;what
would be the code to find the next blank row and make it
the active row ready to receive the next batch of pasted
data.

Help much appreciated.
Thanks
Graham
.

Mike Scobie

Hi Graham,

Give this a bash:

range("a1").end(xldown).offset(1,0).activate

Do you work at Search in Edinburgh with Justin?

Regards,

Mike

-----Original Message-----
I need a quick bit of code please. If I have data in
Columns A:I which I wish to keep adding to via macro;what
would be the code to find the next blank row and make it
the active row ready to receive the next batch of pasted
data.

Help much appreciated.
Thanks
Graham
.

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Index/match - make blank cells return a blank value.	diaare	Excel Worksheet Functions	3	May 3rd 23 03:44 AM
Excel 2002: Return blank when VLOOKUP on blank cells	Mr. Low	Excel Discussion (Misc queries)	2	June 4th 09 05:12 PM
Average Formula to display blank cell if named range is blank	Rachael F	Excel Worksheet Functions	3	February 22nd 08 05:05 PM
Not showing blank and non blank items in filter mode for values	Bhaskar Polisetty	Excel Worksheet Functions	0	June 20th 06 02:04 PM
how to get excel to display blank if reference cell blank	silent1(not)	Excel Worksheet Functions	1	December 2nd 05 02:49 PM

Menu

About Us