Home |
Search |
Today's Posts |
#7
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I know this is lazy, but to save me having to spend time finding out how get
the name of the workbook to use in the definition, any chance you could supply me with the code? The easiest way is probably to use the ThisWorkbook object. Dim wksBLCK_Classified As Worksheet Set wksBLCK_Classified = ThisWorkbook.Worksheets("BLCK Classified") Alternately, you can get the name using the ".name" property debug.print ActiveWorkbook.name or just Dim MyWorkbook as Workbook set MyWorkbook = ActiveWorkbook Good luck |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Custom Functions Available for all Workbooks | Excel Worksheet Functions | |||
custom menu cross contamination between open workbooks. | Excel Programming | |||
How to access ranges in closed workbooks in custom functions | Excel Programming | |||
Excel 2003 Workbooks.Open with CorruptLoad=xlRepairFile fails on Excel 5.0/95 file due to Chart, with Error 1004 Method 'Open' of object 'Workbooks' failed | Excel Programming | |||
Need help with custom open/save functions | Excel Programming |