using variable as cell location

  • Thread starter Thread starter Brad
  • Start date Start date
B

Brad

how can I us a variable as a cell location? ie
Range("c5:variable").Select
 
Brad,

Not sure if I understand you (and let me know if this is not what you were
asking), but all you need to do to use a variable as the parameter for the
Range object:

Dim sCell As String
sCell = "c5"

Range(sCell).Select
 
You can use this Brad

Var = 10
Range("c5:c" & Var).Select

or

Var = "C10"
Range("c5:" & Var).Select
 
Range(C5).Select

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
 
AH! Now I see what the OPS meant.

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
 
Brad,

It depends on what the variable contains. If it is a string
variable with an address, you can use something like

Range("C5:" & Var).Select


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
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

Junp start my Select Case Macro 12
[EASY] I'll become mad ' & "" in variables 2
Some trouble assigning a string to a variable 22
How to Select A Cell in VBA with a Variable Row Number? 3
Variable Range Copy... 13
VBA store location as variable 5
Variable Range, selecting/copying 1
I'm getting unwanted rounding to integer for an average of range of cells. 2

Back
Top