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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Defining a Range using Variables 3
using the address properties from range objects in a sum formula 2
cells.find 1
To give paste special (value) in macros 1
Defining a variable length area for output. 2
assign variable to a range 1
Defined names 3
Excel VBA setting Ranges 2

Back
Top