MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Using VBA to select a range


Posted by Desperado on October 29, 2001 4:14 PM

Hello all,

How can I select a range of cells using something like

Sheets("Sheetname").cells(a,b;c,b).select

All answers show to use... Range("A1:B1").select

My code uses a variable to determine which row(b) to select the cells from. I can select one correct cell no probs but I can't choose more than one.

Basically the code is trying to format cells on the resulting page once a button is pressed to calculate all input information. I use a varialle to place "mini tables". They may not always be placed in the same position on the results as its positioning depends on input from the first page.


Posted by bob umlas on October 29, 2001 4:43 PM

-----------------------
Sheets("Whatever").Range(Cells(a,b),cells(c,b)).Select

Posted by Desperado on October 29, 2001 4:54 PM

I am actually trying that as we speak. Does not work either. I've checked spelling very carefully and I think I've tried exery possible combo there is... heres my latest attempt...

Sheets("Car_Entered").Range(Cells(begin, 1), Cells(begin, 2)).Select

Posted by Desperado on October 29, 2001 5:17 PM

Its still not working :(

Posted by Juan Pablo on October 30, 2001 7:53 AM

Do you get an error message ? or what is going on ?

I mean, that SHOULD work...

Juan Pablo