Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
problem selecting a range using variables
I'm trying to select a range with the use of variables rather than hard
inputs. I am getting an error that says "expected list seperator" when I type the last line of code. Can you guys tell me why this code doesnt work? Private Sub stringtest() Dim col_1 As Long Dim col_2 As Long Dim row_1 As String Dim row_2 As String col_1 = 1 col_2 = 2 row_1 = A row_2 = B Range(col_1&row_1&":"&col_2&row_2&).Select End Sub |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
problem selecting a range using variables
You'll need to take out the last & sign to make the line: Range(col_1 & row_1 & ":" & col_2 & row_2).Select Or replace this lign with: Range(Cells(row_1, col_1), Cells(row_2, col_2)).Select -- colofnature ------------------------------------------------------------------------ colofnature's Profile: http://www.excelforum.com/member.php...o&userid=34356 View this thread: http://www.excelforum.com/showthread...hreadid=544733 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
problem selecting a range using variables
yeah, sorry that last & was my mistake. when I use the line below, it
selects the entire row A and B. I just want to select A1:B2 though. Range(Cells(row_1, col_1), Cells(row_2, col_2)).Select Any help on just selecting a given range and not the entire row? Thanks, Joshua |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
problem selecting a range using variables
This will select A1:B2
Sub One() row1 = 1 row2 = 2 col1 = 1 col2 = 2 Range(Cells(row1, col1), Cells(row2, col2)).Select End Sub "cass calculator" wrote: yeah, sorry that last & was my mistake. when I use the line below, it selects the entire row A and B. I just want to select A1:B2 though. Range(Cells(row_1, col_1), Cells(row_2, col_2)).Select Any help on just selecting a given range and not the entire row? Thanks, Joshua |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Selecting range problem | Excel Programming | |||
Selecting Non-Consecutive Variables | Excel Discussion (Misc queries) | |||
VBA problem pulling data out of variant/range input variables | Excel Programming | |||
Problem selecting a named range | Excel Programming | |||
Problem selecting a range to print... | Excel Programming |