Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Columns now numbers rather than letters how do i get letters back | Excel Discussion (Misc queries) | |||
columns appear as numbers not letters | Excel Discussion (Misc queries) | |||
I have numbers instead of letters on my columns, why? | Excel Discussion (Misc queries) | |||
Help, my columns now have numbers instead of letters. | Excel Discussion (Misc queries) | |||
Columns in letters vs numbers | Excel Discussion (Misc queries) |