| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
variable paste or fill range
Using VBA I need to paste a named formula "BinTest" into a range of
cells in a column. Starting at A37. The length of the range of cells is dependant upon the value of another name "Range". I want this to fire when the worksheet is selected if that is possible. I think I need to use a fill function and somehow check the value of "Range" and then say fill down from A37 but I have no idea where to start. Any help, code examples, etc. will be appreciated Robert |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to Copy and Paste a variable range | Excel Programming | |||
| Copy/paste range variable between workbooks | Excel Programming | |||
| Fill a listbox with data from variable range | Excel Programming | |||
| Macro to Paste to a Variable Range - HELP | Excel Programming | |||
| Paste a Range from a variable | Excel Programming | |||
Threaded Mode
