Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Date is not permanent | New Users to Excel | |||
how do you get a permanent cache? | Excel Discussion (Misc queries) | |||
Permanent Reference | Excel Discussion (Misc queries) | |||
Permanent formula? | Excel Worksheet Functions | |||
Permanent Variable? | Excel Programming |