B
Brad
how can I us a variable as a cell location? ie
Range("c5:variable").Select
Range("c5:variable").Select
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
C
Charles Maxson
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
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
R
Ron de Bruin
You can use this Brad
Var = 10
Range("c5:c" & Var).Select
or
Var = "C10"
Range("c5:" & Var).Select
Var = 10
Range("c5:c" & Var).Select
or
Var = "C10"
Range("c5:" & Var).Select
N
Niek Otten
Range(C5).Select
--
Kind Regards,
Niek Otten
Microsoft MVP - Excel
--
Kind Regards,
Niek Otten
Microsoft MVP - Excel
N
Niek Otten
AH! Now I see what the OPS meant.
--
Kind Regards,
Niek Otten
Microsoft MVP - Excel
--
Kind Regards,
Niek Otten
Microsoft MVP - Excel
C
Chip Pearson
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
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