Select Range using variables

**rvc81** · 12-08-2010, 07:47 AM

with the above code the column selection is ok but it selects 5 extra rows

Thanks
R

**snb** · 12-08-2010, 07:59 AM

Can't tell without seeing your worksheet.
But most likely the last 5 cells in column A are not empty (although they give that impression). Delete those last 5 rows and try again.

**rvc81** · 12-08-2010, 08:05 AM

I think you are right, I tried the code in a new sheet and it works perfectly fine.

Thanks again.

R

Select Range using variables

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Re: Select Range using variables

Re: Select Range using variables

Re: Select Range using variables

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions