| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Insert range of cells with a (UDF) function
Hi,
I have several ranges defined( range1=$1:$15, range2=$16:$20, range3=$20:$30) Depending on a cell value I want to insert one of tese ranges. e.g. InsRange("range"&A1) Is should be possible with a VBA function, but I dont have any VBA experience |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Insert range of cells with a (UDF) function
You cannot achieve this with a UDF, as they can only (with a few exceptions)
return a value to a cell. What do you mean by "Depending on a cell value I want to insert one of tese ranges" ? NickHK "firsttimer" wrote in message ... Hi, I have several ranges defined( range1=$1:$15, range2=$16:$20, range3=$20:$30) Depending on a cell value I want to insert one of tese ranges. e.g. InsRange("range"&A1) Is should be possible with a VBA function, but I dont have any VBA experience |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Insert range of cells with a (UDF) function
See response in worksheetfunctions.
-- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "firsttimer" wrote in message ... Hi, I have several ranges defined( range1=$1:$15, range2=$16:$20, range3=$20:$30) Depending on a cell value I want to insert one of tese ranges. e.g. InsRange("range"&A1) Is should be possible with a VBA function, but I dont have any VBA experience |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Insert Range Of Cells | Excel Programming | |||
| Insert range of cells with a function | Excel Worksheet Functions | |||
| How do I insert a calculated cell range into an excel function | Excel Worksheet Functions | |||
| Insert range function and CopyOrigin | Excel Programming | |||
| Insert SUM function for range | Excel Programming | |||
Linear Mode
