Code Not working Right ??

[wysbob]

Good morning all, being new to VBA I am struggling slightly with a bit of code that will excel select the next available empty row in a workbook. I have managed to partially figure it out but its not working right and I am getting in error. I have been trying

Please Login or Register  to view this content.

Line 1 works ok
Line 2 works ok - A6 is the last cell that has text
Line 3 ??? - this should take me from A6 to the next cell A7 to paste information into it taking me down to say A11

This code will be used to continually add new information to the sheet therefore the next batch of information would be pasted into A12 etc.

Thanks in advance for your help

Sandy

[BadlySpelledBuoy]

You could use .OFFSET(1,0) before select on line 2. That would take you to the next row and negate the need for row 3.

BSB

[Norie]

Accidental duplicate.

[Norie]

You could aye just use one line.

Please Login or Register  to view this content.