Using VBA to select a range
Posted by Desperado on October 29, 2001 4:14 PM
How can I select a range of cells using something like
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.