J Jammie Mar 13, 2004 #1 I need to be able to assign a global variable that can easily be accessed from anywhere with excel. How can I do this? Jamie
I need to be able to assign a global variable that can easily be accessed from anywhere with excel. How can I do this? Jamie
C Chip Pearson Mar 13, 2004 #2 Jamie, Declare the variable as a Public variable, in a standard code module, outside of and prior to any procedure. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com
Jamie, Declare the variable as a Public variable, in a standard code module, outside of and prior to any procedure. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com
J Jammie Mar 13, 2004 #3 ok thanks for your help! Chip Pearson said: Jamie, Declare the variable as a Public variable, in a standard code module, outside of and prior to any procedure. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com Click to expand...
ok thanks for your help! Chip Pearson said: Jamie, Declare the variable as a Public variable, in a standard code module, outside of and prior to any procedure. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com Click to expand...
