macro with dynamic input

[Guest]

Hi all

I want to pass on cell value of A1 into VB script every time i run a macro

which command should i use?

 

[Susan]

are you taking about VB or VBA? there's a difference.
if you're talking about VBA, then all you have to do is declare the
variable. as long as that worksheet is still open, the variable will
still be there.........

for code in THAT worksheet:

dim myValue as variant
myValue = worksheet("sheet1").range("A1")

for code in a DIFFERENT workbook (that must be open):
dim myValue as variant
dim wb1 as workbook
dim ws1 as worksheet

set wb1 = DifferentWorkbook.xls
set ws1 = Worksheets(1)

myValue = wb1.ws1.range("A1")

if you're talking about VB, i don't know. try the programming
newsgroup.

susan

 

[Guest]

Thanks Susan

I got hint from your reply

dim myValue as variant
myValue = worksheet("sheet1").range("A1")