![]() |
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 |
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 |
All times are GMT +1. The time now is 08:46 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com