| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Subtotal another open sheet in VBA
I am trying to use the worksheet function along with Subtotal to get the
total of a range on another sheet and place it in the main spreadsheet. Cells(49, C) = Workbooks(WrkBk).Worksheets("Billable FT").WorksheetFunction.Subtotal(9, xlRng) Where XlRng is Range, WrkBk is a value from an array. If I remove the worksheet and workbook references, it runs locally. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| To copy subtotal into another sheet | Excel Discussion (Misc queries) | |||
| Unhide column based on subtotal level open. | Excel Discussion (Misc queries) | |||
| why, when i open a work sheet does a blank sheet open as well | Excel Discussion (Misc queries) | |||
| Using the subtotal function on a prtected sheet | Excel Worksheet Functions | |||
| copy subtotal information to new sheet | Excel Worksheet Functions | |||
Hybrid Mode
