| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Naming Range Variables
If I want to pass the variable iRefStart to the DeleteCells() Function, what
syntax is needed? Below, I'm just trying to say"Start at Cell B1" Sub CleanSpreed() iRefStart = "B" Call DeleteCells(iRefStart) Function DeleteCells(ByVal iRefStart As String) Dim rng As Range Set rng = Range(iRefStart & "1:B10") |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Naming a range | Excel Discussion (Misc queries) | |||
| plotting 2 variables as scatter and naming each point | Charts and Charting in Excel | |||
| Naming Variables | Excel Programming | |||
| VB Code Naming a Range (range changes each time) | Excel Programming | |||
| naming multiple public variables generated by single function | Excel Programming | |||
Threaded Mode
