Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 38
Default Copy Used Range

I have a workbook with several sheets; I am trying to create a dynamic
summary page - one where the cell values are live links to the cells on the
other sheets.
The sheets I am copying have variable used ranges.
I can copy the used range (Thanks Ron DeBruin), but I am unable to have the
result show as "=sheetname!celladdress".

Any help is appreciated.

Thanks
 
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
copy a specified name range Lori New Users to Excel 9 January 10th 07 01:13 PM
How do I copy formulas but using the same range each time I copy Laffin Excel Worksheet Functions 2 June 22nd 06 04:17 PM
help with range copy saziz Excel Discussion (Misc queries) 4 September 29th 05 06:34 PM
copy a range without the same value antoine Excel Discussion (Misc queries) 1 May 4th 05 12:18 PM
Copy a range GrantM Excel Worksheet Functions 1 December 21st 04 09:59 AM


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

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

About Us

"It's about Microsoft Excel"