Hi All
How can I select more than one column of a Worksheet object if I have
the columns as numbers(long) and not characters?
That is, in my example, simplified code I have:
Dim lColStart As Long, lColEnd As Long
lColStart = 1
lColEnd = 3
I want to select all columns from lColStart to lColEnd on the
ActiveSheet. It seems that
VB wants:
ActiveSheet.Columns("A:C")
but I want to use my longs only - I dont want to have to convert them
to characters with a helper sub.
I must be missing something - how can I use my longs to select the
columns?
Thanks in advance for any ideas.
Chrisso