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
|