Select area between two bottom rows

**jomili** · 05-12-2011, 08:44 AM

I have data in Column A, and in Column B. I want to select the area from the bottom of column A to the bottom of column B (really, I want to delete that area). Here's the code I'm trying to use:

Firstrow = Range("A" & Rows.Count).End(xlUp).Row
    LastRow = Range("B" & Rows.Count).End(xlUp).Row
    Range(Firstrow:LastRow).Select

The last line has a syntax error, but I dont know how to resolve the syntax. Can someone help?

**TMS** · 05-12-2011, 08:54 AM

Is this what you're looking for:

Firstrow = Range("A" & Rows.Count).End(xlUp).Row
LastRow = Range("B" & Rows.Count).End(xlUp).Row
Range(Firstrow & ":" & LastRow).Select

Regards

**jomili** · 05-12-2011, 08:59 AM

Thanks TMShucks; that was 99.9% of what I needed. I just had to add an offset to my Firstrow line. See code below:

Firstrow = Range("A" & Rows.Count).End(xlUp).Offset(1, 0).Row
LastRow = Range("B" & Rows.Count).End(xlUp).Row
Range(Firstrow & ":" & LastRow).Select

Syntax seems to be my biggest issue, so I'm very grateful to folks like you who step in and help out. God bless you!

Thanks,
John

Select area between two bottom rows

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Select area between two bottom rows

Re: Select area between two bottom rows

Re: Select area between two bottom rows

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions