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
store the variable value in any unused cell.
Sheets("Data").Range("A1") = A
This method maintains the value of the variable even after the workbook is
closed and re-opened.
Regards - Dave.
Date: Mon, 1 Mar 2010 02:31:53 +0530
Subject: $$Excel-Macros$$ Data in variables
From: harp
Hi,
Is it possible to keep the value stored in the variable till the time the
sheet is running or the code is running.
Example: I have to a variable A and B, which i need to use to store
information from a form, this information will be used in other modules or
procedures. Is it possbile to keep
