| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I create this range?
I am trying to set a range in vba, but am having trouble figuring out how to
code it. I know the proper syntax is normally this: MyRange = Worksheets(ActSheet).Range("C5:C50") My problem is that I won't have the LETTER (like C) of the column, only the number, like instead of column "C" I would have a number 3. So basically, how can I replace the ("C5:C50") portion with integer type variables? Thanks in advance |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| create range bar graph | Charts and Charting in Excel | |||
| How do I create a Range Name? | New Users to Excel | |||
| Trying to create a range in an IF function | Excel Worksheet Functions | |||
| Create/copy combo boxes in one range if condition is met in a different range | Excel Programming | |||
| create a chart without set range | Excel Programming | |||
Threaded Mode
