Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
What am I doing wrong with this VBA range?
This works:
Dim myRange As Range Set myRange = Worksheets("Collection").Range("H2:H4") But the change below doesn't work for some reason and presents an error: Dim refColumn As String Dim myRange As Range refColumn = "H" Set myRange = Worksheets("Collection").Range(refColumn & "2:" & refColumn & "4") What have I done wrong? Thanks in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
What is wrong with this range??? | Excel Programming | |||
right code, wrong range | Excel Programming | |||
Range in wrong book | Excel Programming | |||
histogram, wrong input range | Excel Discussion (Misc queries) | |||
deleting wrong range! | Excel Programming |