Re: $$Excel-Macros$$ how to declare define global range in vba

2010-02-03 Thread Swapnil Palande
-- *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

$$Excel-Macros$$ how to declare define global range in vba

2010-02-02 Thread Ayush
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

Re: $$Excel-Macros$$ how to declare define global range in vba

2010-02-02 Thread Paul Schreiner
@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

RE: $$Excel-Macros$$ how to declare define global range in vba

2010-02-02 Thread Dave Bonallack
Hi Ayush, What do you mean by outside the procedure'? Dave. Date: Tue, 2 Feb 2010 08:24:36 -0800 Subject: $$Excel-Macros$$ how to declare define global range in vba From: jainayus...@gmail.com To: excel-macros@googlegroups.com Hello Group, How can we declare and define Global range

Re: $$Excel-Macros$$ how to declare define global range in vba

2010-02-02 Thread ayush jain
...@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