LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 42
Default Paste values all cells in a region which refers to out of region

Hi,
Suppose I have a region N100 to Y200, now I would like to paste values all
the cells in the region which refers to the cell out of this region.
The requirement is I have prepared a cash flow where values are coming from
different sheets and workbooks. Also few formulas of sum, minus and
percentage refers in this particular region only. I have to send this sheet
to somebody wherein all formulas refering to this region should not be
changed while all other cells should be paste values.


 
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
how to find used region with macro Oerjan New Users to Excel 3 December 12th 08 09:36 AM
Additional raws only in some region antares Excel Discussion (Misc queries) 10 November 30th 08 01:23 AM
Counting a Region Paul D Byrne. Excel Worksheet Functions 2 November 27th 08 03:01 AM
VBA determine computer region Viperv10 Setting up and Configuration of Excel 5 May 27th 07 01:39 AM
Region Zaahir Excel Discussion (Misc queries) 2 November 14th 06 02:22 PM


All times are GMT +1. The time now is 11:38 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"