| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using variables as first and last cells in range statement
How do you specify the 'RANGE(a:b).SELECT' statment using only
variables. I keep getting syntax errors when I attempt the following: Dim endcell As String endcell = Range("D65535").End(xlUp).Row Dim firstcell As String firstcell = Range(FinalRow - 4).Select Range(firstcell:endcell).Select |
Threaded Mode
