View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Tom from Ga
 
Posts: n/a
Default 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