C
choua_yang22
Does anyone know how reference a cell in VBA and be able to use that
reference in another method?
For example:
sub test1()
date = sheets("today").range("D2")
end sub
sub test2()
msgbox = "today's date is " & date
end sub
Can not seem to be able to set Date Permanently so that I can use the
reference
in any method I want. Once it goes to the second sub, date is dropped
and now empty.
Thank you for helping me out. I appreciate any help I can get.
Kevin Yang
reference in another method?
For example:
sub test1()
date = sheets("today").range("D2")
end sub
sub test2()
msgbox = "today's date is " & date
end sub
Can not seem to be able to set Date Permanently so that I can use the
reference
in any method I want. Once it goes to the second sub, date is dropped
and now empty.
Thank you for helping me out. I appreciate any help I can get.
Kevin Yang