http://www.cpearson.com/excel/FindAll.aspx
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguillett1@gmail.com
From: Torstein Johnsen
Sent: Saturday, October 06, 2012 10:43 AM
To: ExcelVBA@yahoogroups.com
Subject: Vedr: [ExcelVBA] search in workbook (all sheets) - VBA
Anyone having any suggestions on my question some days ago? Or maybe my explanation was not good enough?
I have a workbook with multiple sheets. By the menu I do searches (FIND) in all worksheets.
In the FIND dialogbox you can have "FIND in workbook" (searching in all worksheets), but it's not possible to choose this as default.
Thats why I tried to record a macro choosing "FIND in workbook". But this doesn't work either.
Any suggestions?
Torstein
________________________________
Fra: Torstein Johnsen <mailto:sejohnse%40yahoo.no>
Til: "mailto:ExcelVBA%40yahoogroups.com" <mailto:ExcelVBA%40yahoogroups.com>
Sendt: Mandag, 1. oktober 2012 20.58
Emne: [ExcelVBA] search in workbook (all sheets) - VBA
I have a workbook with multiple sheets. I do searches in all worksheets.
It's not possible to have "search in workbook" as default.
Thats why I tried to record a macro choosing "searh in workbook". But this doesn't work either.
Any suggestions?
regards
Torstein
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (8) |
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.
----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA
----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com
----------------------------------
Tidak ada komentar:
Posting Komentar