View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] choua_yang22@yahoo.com is offline
external usenet poster
 
Posts: 2
Default VBA Permanent Code

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