using variables to define range

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

have set value of startref and endref from activecell.address us
now want to use to select range ie select startref:endref but it wants it as "[startref]:[endref]" ie in quotes but how do i do this if it wont evaluate to text?
David
 
Back
Top