Mike EHB-Docks

Posts: n/a

adding named ranges

I have two ranges of cells named range1 and range2 but I am unable to add
them together as =sum(range1+range2) gives me an error

Any help would be appreciated.

Mike

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
Macro (Print) - Calling Named Ranges	KGlennC	Excel Discussion (Misc queries)	1	March 19th 05 09:20 PM
Named Ranges	Donna	Excel Discussion (Misc queries)	3	February 1st 05 11:35 PM
Poor Workbook Performance due to Named Ranges	jrusso	Excel Discussion (Misc queries)	2	January 10th 05 11:39 PM
How to Link named ranges from multiple Workbooks into a single Wo.	PMAP_HELP	Excel Discussion (Misc queries)	1	December 14th 04 05:51 PM
Named dynamic ranges, copied worksheets and graph source data	WP	Charts and Charting in Excel	1	November 28th 04 05:19 PM

All times are GMT +1. The time now is 12:04 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us