View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
jbarrington jbarrington is offline
external usenet poster
 
Posts: 8
Default 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.