What module are you putting the declaration in?
For instance, if you right-click on a sheet "tab" and select "View Code"
it opens up the VBA "Sheet Module".
You'll notice a module called "ThisWorkBook"
If you create "standard" Modules, there will be a "folder" called "Modules"
and a list of modules (default names are Module1, Module2)
A "standard" module will be created if you record a macro.
You cannot declare Public variables in Sheet modules.
They MUST be in 'standard' modules.
Although they MIGHT be allowed in 'class' modules, but not in "form" modules.
Next.
You can DECLARE it using:
Public
but I think you have to SET it within a macro.
I THINK basically it's because sheets and ranges are "dynamic"
and you're trying to treat a variable as a constant....
But I could be wrong.
Paul
________________________________
From: Ayush <jainayus...@gmail.com>
To: MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com>
Sent: Tue, February 2, 2010 11:24:36 AM
Subject: $$Excel-Macros$$ how to declare & define global range in vba
Hello Group,
How can we declare and define Global range in vba , so that it can be
used across procedures & modules ?
Public rngNetLineAmt as range
Set rngNetLineAmt = Sheets("M-RAW").Range("AQ:AQ")
If i use above code outside the procedure..it does not work and throws
error.
Kindly advise.
Thank you so much.
-Ayush Jain
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
http://www.excelitems.com
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain @ jainayus...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
We reach over 6,700 subscribers worldwide and receive many nice notes about the
learning and support from the group.Let friends and co-workers know they can
subscribe to group at http://groups.google.com/group/excel-macros/subscribe
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
http://www.excelitems.com
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain @ jainayus...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
We reach over 6,700 subscribers worldwide and receive many nice notes about the
learning and support from the group.Let friends and co-workers know they can
subscribe to group at http://groups.google.com/group/excel-macros/subscribe
