Thank you so much shyam for your immediate reply
Cheers
Harpreet
Sent on my BlackBerry® from Vodafone Essar
-Original Message-
From: rf1234 rf1234
Date: Thu, 4 Mar 2010 11:24:33
To:
Cc:
Subject: Re: $$Excel-Macros$$ Data in variables
Dear Harpreet
I have attach the example showing
#x27;''''''''''''''''''''''''''''''''''''''''''''''''''''
Hello Dear
definately it is possible,when u write the code for particular
workbook in module,it will reside till workbook exist.
hope it will help.
happy to help
:)
shyam
On Mon, Mar 1, 2010 at 2:31 AM, Harpreet Singh Gujral <
harpreetguj...@gmail.com> wrote:
> Hi,
>
> Is it possible to keep th
Hi,
Two ways I know of:
Public A As ...
as opposed to:
Dim A As ..
The 'Public' statement goes in any module, but outside any sub.
The value of the variable will be available while the workbook remains open,
but will be lost when the workbook closes.
The other way is to store the variable
