Select rows until blank row

**SKhan** · 12-15-2008, 03:53 PM

I need to select the cells from row 2 until a blank row is met.
There is no specific range as I intend to insert these rows in another sheet.
Any suggestions please?

**VBA Noob** · 12-15-2008, 04:00 PM

Maybe

Please Login or Register  to view this content.

VBA Noob

**SKhan** · 12-15-2008, 04:38 PM

It doesn't copy the whole row, it only copies the data from row 1 column A to all the columns from the other sheet.

**VBA Noob** · 12-15-2008, 04:39 PM

Change to

Please Login or Register  to view this content.

VBA Noob

**SKhan** · 12-15-2008, 05:14 PM

now it copies and inserts row 25 although the first blank cell was A6

**VBA Noob** · 12-15-2008, 05:15 PM

copies and inserts row 25

My code doesn't insert anything?

VBA Noob

**SKhan** · 12-15-2008, 05:24 PM

just a blank row, as I said... row 25. I can't understand why... before I entered EntireRow it copied the selection from A1:A5 but now it always copies from A25.

This is the code.
If you create a History with Track Changes you can notice that before the text "History ends...." there is always a blank row.

Please Login or Register  to view this content.

Edit: stupid typo was to blame... I forgot to add :A to the Range selection.

Please Login or Register  to view this content.

My bad.. editing the issue solved now.

**VBA Noob** · 12-15-2008, 05:35 PM

By declaring the LastRow at the top then selecting the new sheet the LastRow will be that of the active sheet

Try

Please Login or Register  to view this content.

VBA Noob

Select rows until blank row

LinkBack

Thread Tools

Rate This Thread

Display

Select rows until blank row

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions