Posted to microsoft.public.excel.programming

firsttimer firsttimer is offline

external usenet poster

Posts: 7

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Insert Range Of Cells	firsttimer	Excel Programming	4	May 29th 07 11:38 AM
Insert range of cells with a function	firsttimer	Excel Worksheet Functions	2	May 29th 07 09:43 AM
How do I insert a calculated cell range into an excel function	Gary Wallis	Excel Worksheet Functions	2	April 26th 07 03:28 PM
Insert range function and CopyOrigin	No Name	Excel Programming	7	January 2nd 04 02:33 AM
Insert SUM function for range	Denis Petrov	Excel Programming	3	October 21st 03 06:44 PM

All times are GMT +1. The time now is 12:22 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us