Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Understanding macro statement
I am trying to troubleshoot a macro but unfortunately I don't have much experience. Can anyone help me understand what these statements do: formula.find formula.goto formula.replace get.document get.workbook options.calculation paste.special workbook.insert workbook.name workbook.next workbook.prev workbook.select I can guess what some do but I would appreciate if anyone can shed some light on this. Thanks. -- HWMI ------------------------------------------------------------------------ HWMI's Profile: http://www.excelforum.com/member.php...o&userid=36248 View this thread: http://www.excelforum.com/showthread...hreadid=560412 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Understanding macro statement
sure some of these aren't from WORD?
Others may just be variables, so no way of telling what object they refer to. for example, the workbook object doesn't have an insert method. -- Regards, Tom Ogilvy "HWMI" wrote: I am trying to troubleshoot a macro but unfortunately I don't have much experience. Can anyone help me understand what these statements do: formula.find formula.goto formula.replace get.document get.workbook options.calculation paste.special workbook.insert workbook.name workbook.next workbook.prev workbook.select I can guess what some do but I would appreciate if anyone can shed some light on this. Thanks. -- HWMI ------------------------------------------------------------------------ HWMI's Profile: http://www.excelforum.com/member.php...o&userid=36248 View this thread: http://www.excelforum.com/showthread...hreadid=560412 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help understanding CSE results | Excel Discussion (Misc queries) | |||
Understanding SUMPRODUCT() | Excel Worksheet Functions | |||
Not understanding with/end with | Excel Programming | |||
NOT UNDERSTANDING THE FORMULA | Excel Worksheet Functions | |||
Not understanding If Not..Then nothing | Excel Programming |