Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
VBA syntax
I have some code in a macro that was recorded like this:
TableDestination:="[MyWorkbook.xlsm]Sales!R5C1" I would like to replace Myworkbook.xlsm with "ActiveWorkbook Is this the syntax: TableDestination:="[ActiveWorkbook]Reorder!R5C1" ? OR TableDestination:="ActiveWorkbook.Reorder!R5C1" OR something else? Thanks for any help on this |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VB Syntax | Excel Discussion (Misc queries) | |||
The NOW() syntax | Excel Discussion (Misc queries) | |||
IRR Syntax | Excel Worksheet Functions | |||
Help with Syntax | Excel Discussion (Misc queries) | |||
VBA syntax | Excel Discussion (Misc queries) |