Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
jmt jmt is offline
external usenet poster
 
Posts: 5
Default Is there an INDIRECT function for a RANGE?

I'm trying to find the equivalent of the INDIRECT function, but instead of a
cell location, I'd like to "build" a Range. As an example, I'd like to
convert the following text, "CONCATENATE("Sheet","'!A1:B4") to a range that
Excel can understand. If this were simply a cell reference, then the text
string could be the argument for the INDIRECT function. Is there a way to do
this? Thanks in advance
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 15,768
Default Is there an INDIRECT function for a RANGE?

Not sure what you're looking for but it'll work as you describe.

D1 = text string: Sheet1!A1:B4

=SUM(INDIRECT(D1))

D1 = a formulated reference: ="Sheet1!A"&A1&":B"&B1

Where A1 and B1 contain the row numbers

=SUM(INDIRECT(D1))

--
Biff
Microsoft Excel MVP


"jmt" wrote in message
...
I'm trying to find the equivalent of the INDIRECT function, but instead of
a
cell location, I'd like to "build" a Range. As an example, I'd like to
convert the following text, "CONCATENATE("Sheet","'!A1:B4") to a range
that
Excel can understand. If this were simply a cell reference, then the text
string could be the argument for the INDIRECT function. Is there a way to
do
this? Thanks in advance



  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
jmt jmt is offline
external usenet poster
 
Posts: 5
Default Is there an INDIRECT function for a RANGE?

Thank you. My error was omiting an apostrophe (') before th sheet name.

"T. Valko" wrote:

Not sure what you're looking for but it'll work as you describe.

D1 = text string: Sheet1!A1:B4

=SUM(INDIRECT(D1))

D1 = a formulated reference: ="Sheet1!A"&A1&":B"&B1

Where A1 and B1 contain the row numbers

=SUM(INDIRECT(D1))

--
Biff
Microsoft Excel MVP


"jmt" wrote in message
...
I'm trying to find the equivalent of the INDIRECT function, but instead of
a
cell location, I'd like to "build" a Range. As an example, I'd like to
convert the following text, "CONCATENATE("Sheet","'!A1:B4") to a range
that
Excel can understand. If this were simply a cell reference, then the text
string could be the argument for the INDIRECT function. Is there a way to
do
this? Thanks in advance




  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 15,768
Default Is there an INDIRECT function for a RANGE?

Thanks for feeding back!

--
Biff
Microsoft Excel MVP


"jmt" wrote in message
...
Thank you. My error was omiting an apostrophe (') before th sheet name.

"T. Valko" wrote:

Not sure what you're looking for but it'll work as you describe.

D1 = text string: Sheet1!A1:B4

=SUM(INDIRECT(D1))

D1 = a formulated reference: ="Sheet1!A"&A1&":B"&B1

Where A1 and B1 contain the row numbers

=SUM(INDIRECT(D1))

--
Biff
Microsoft Excel MVP


"jmt" wrote in message
...
I'm trying to find the equivalent of the INDIRECT function, but instead
of
a
cell location, I'd like to "build" a Range. As an example, I'd like to
convert the following text, "CONCATENATE("Sheet","'!A1:B4") to a range
that
Excel can understand. If this were simply a cell reference, then the
text
string could be the argument for the INDIRECT function. Is there a way
to
do
this? Thanks in advance






Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Allow EXCEL INDIRECT(ADDRESS()) and INDIRECT(RANGE()) functions Mike Barlow Excel Worksheet Functions 7 May 21st 23 07:42 PM
function like INDIRECT to return a range? Wilba Excel Worksheet Functions 4 November 17th 07 05:42 AM
can I use Indirect function within range definitons for names? surreyjed Excel Worksheet Functions 1 November 1st 07 08:14 PM
Indirect Range [email protected] Excel Worksheet Functions 0 September 28th 05 05:01 PM
How to paste INDIRECT function to range of cells? Mike Williams Excel Worksheet Functions 4 March 18th 05 04:02 AM


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

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"