agarwaldvk
11-12-2007, 01:54 PM
Hi Everybody
Can anyone suggest how to create a range name (say for the range A1:D100) on four different worksheets say (W1, W3, W5 and W7). Please note these worksheets are not arranged sequentially one after the other and hence obviously I cannot the colon (:) range operator. There is no guarantee that these WILL always be arranged in a sequential order - it cannot be assumed to be so.
I am not inclined to use different range names one for each worksheet since I will be having a few of them and hence the formula will become very unwieldy.
Something like so is obviously wrong but in the same vein perhaps may work if someone can lead me to it :-
TestRange = W1!A1:D100,W3!A1:D100,W5!A1:D100,W7!A1:D100
Best regards and thanks
Deepak Agarwal
Can anyone suggest how to create a range name (say for the range A1:D100) on four different worksheets say (W1, W3, W5 and W7). Please note these worksheets are not arranged sequentially one after the other and hence obviously I cannot the colon (:) range operator. There is no guarantee that these WILL always be arranged in a sequential order - it cannot be assumed to be so.
I am not inclined to use different range names one for each worksheet since I will be having a few of them and hence the formula will become very unwieldy.
Something like so is obviously wrong but in the same vein perhaps may work if someone can lead me to it :-
TestRange = W1!A1:D100,W3!A1:D100,W5!A1:D100,W7!A1:D100
Best regards and thanks
Deepak Agarwal