Posted to microsoft.public.excel.misc,microsoft.public.excel.programming

teepee[_3_] teepee[_3_] is offline

external usenet poster

Posts: 107

Indirect question

I want range ("CB4:CN289") to indirectly reference Range ("BL4:BX289")

As far as I can see I have to enter the indirect command into each cell
individually. Is there an obvious way of mass producing and doing it in one
go?

Many thanks

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
INDIRECT Question..	Nastech	Excel Discussion (Misc queries)	0	October 24th 08 04:25 AM
Yet Another 'INDIRECT' Question	Suzanne	Excel Worksheet Functions	4	October 19th 07 08:32 PM
A question about INDIRECT()	Shuang	Excel Worksheet Functions	5	October 12th 07 06:47 PM
Indirect question	saveas getting rid of formulas	Excel Discussion (Misc queries)	6	February 3rd 06 03:36 PM
INDIRECT.EXT question	SU	Excel Worksheet Functions	8	April 12th 05 07:57 PM

All times are GMT +1. The time now is 03:30 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us