| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Variable refers to a workbook
Excellent. Thanks!
"Jackpot" wrote: Use the Set statement which assigns an object reference to a variable or property. Dim mywkbk as workbook Set mywkbk = Activeworkbook Msgbox myWkbk.Name Msgbox myWkbk.Sheets.Count |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need variable that refers to same row different column | Excel Discussion (Misc queries) | |||
| Running macro in one workbook that refers to variable in another | Excel Programming | |||
| Variable in one sub which refers to an input box in another sub. | Excel Programming | |||
| Name assigned in workbook refers to range problem!!! | Excel Programming | |||
| macro button refers to prev. workbook | Excel Programming | |||
Hybrid Mode
