Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Insert range of cells with a 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.worksheet.functions
|
|||
|
|||
Insert range of cells with a function
Rows("1:15").Name = "Range" & Range("A1")
-- 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Insert range of cells with a function
Please don't crosspost. See answers to your questions in the Programming
group. Joerg "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 | |||
How do I insert a calculated cell range into an excel function | Excel Worksheet Functions | |||
after entering insert function my cells run down and off page | Excel Discussion (Misc queries) | |||
insert picture to a specfic range of cells | Excel Discussion (Misc queries) | |||
How to paste INDIRECT function to range of cells? | Excel Worksheet Functions | |||
Function to return the latest non-zero value in a range of cells . | Excel Worksheet Functions |