how can I us a variable as a cell location? ie Range("c5:variable").Select
C Charles Maxson Jan 5, 2004 #2 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
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
C Chip Pearson Jan 5, 2004 #4 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
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
