Reference Global vars in cell formulas?

Posted to microsoft.public.excel.programming

external usenet poster

Posts: 119

Reference Global vars in cell formulas?

Is it possible to reference global/public vars in cell forumulas?

I want to create a function that sets a global variable say true and false,
and have a cell formula that has an if statement:

=if([Globalvar], do something, "")

I can't use a UDF because it causes other Macros I have to fail with
RunTimeError 1004. It's something about UDFs not allowed to alter other
cells, but the UDF wouldn't be modiying cells, but my non-UDF macros are.

So, I'm experimenting with a different approach.

Ideas?

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
Graph data series formulas: How to global-change all sheet reference to formula	[email protected]	Excel Discussion (Misc queries)	1	January 20th 09 05:32 AM
Pivot tables - can change row/col vars but can't get rid of existing vars	Andreww	Excel Programming	0	May 25th 07 11:50 AM
Formulas that reference cells that reference another cell	Andrea	Excel Discussion (Misc queries)	7	October 19th 06 08:14 AM
Changing Cell Reference in a macro on global base	ashish128	Excel Discussion (Misc queries)	2	April 20th 06 01:16 PM
Global vars	Nath	Excel Programming	1	July 13th 04 04:20 PM

All times are GMT +1. The time now is 05:14 AM.

Menu

About Us