Select Range using variables

**rvc81** · 12-08-2010, 06:51 AM

Hi,

I have set variables to identify the first row, last row, and last column. when I try to select the range it gives me an error.

Please Login or Register  to view this content.

Thanks
R

**snb** · 12-08-2010, 06:58 AM

No need for variables:

Please Login or Register  to view this content.

maybe this will give the same result

Please Login or Register  to view this content.

or even

Please Login or Register  to view this content.

But in general you should avoid 'activate' and 'select' in VBA.

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

thank you so much for the code.

I have used the the first code, it selects the range but selects 1 extra column and 5 extra rows.

R

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

This will select 1 column and 1 row less:

Please Login or Register  to view this content.

**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

Select Range using variables

Re: Select Range using variables

Re: Select Range using variables

Re: Select Range using variables

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