PC Review

Thread Tools Rate Thread

automatic range - named range give me circular reference...

George Thorogood
Posts: n/a
      22nd Feb 2007

Hello. I want to put some functions down at the bottom of a column. Like a count of visible unique cells.
Found VBA script for that. But I want the range to be dynamic. Like from A2 to row of the function in question
- 1 in the A column. So if my function is currently at the bottom of the column at A87, I want the range to be A2:A86.
Found the method for named dynamic ranges, but, it gives me a circular reference error when I try to actually use
it in the function. So is there another method or way to fix the circular reference problem?

Reply With Quote

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Selecting a named range, the name of the named range is in a cell Luc Microsoft Excel Programming 6 13th Jan 2010 08:35 PM
Circular or semi-circular chart DKS Microsoft Excel Charting 3 3rd Nov 2009 02:50 PM
Putting Formula in all cells give Circular Reference. Please help K Microsoft Excel Programming 7 18th Aug 2009 04:58 PM
Array as a "named range" - formula ok in cells, but error as "named range" tskogstrom Microsoft Excel Misc 11 28th Dec 2006 05:44 PM
Circular Reference Error but there is no circular reference error! =?Utf-8?B?SmVycnlKdWljZQ==?= Microsoft Excel Crashes 3 31st Oct 2005 07:13 PM




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