Using VBA to select a range

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.