| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Why it can work in Function but ok in Sub
Can anyone tell me why the following code cannot work in Function but ok in
a Sub? In Function, the statement Workbooks("testing.xls").Activate doesn't work, but ok in Sub Thanks Function no_of_HK_working_day(date1 As Date, date2 As Date, half_sat As Double) Set wb_current = ActiveWorkbook Workbooks("testing.xls").Activate Set wb_holiday = ActiveWorkbook wb_current.Activate End Function |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Why won't this function work? | Excel Worksheet Functions | |||
| Function doesn't work | Excel Worksheet Functions | |||
| need a function that will work using multiple work books and sheet | Excel Worksheet Functions | |||
| how do i get the mid function to work with a zero | Excel Worksheet Functions | |||
| Why it can work in Function but ok in Sub | Excel Programming | |||
Threaded Mode
