| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Use sheet name as search string or autofilter criteria
Hi all,
1 I am trying to develop a project in which I have to search the sheet with the sheet name. How can I code the same in VBA-Excel? 2 I also need to use filters with the criteria as sheet name. How to code it in VBA-Excel? Any help appreciated. Thankx, Magar |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Use sheet name as search string or autofilter criteria
How can I code the same in VBA-Excel?
Well, where you would normally search for a text string you would instead use something like: Cells.Find ActiveSheet.Name I imagine this isn't a huge help to you but it's hard to do more based on your message. If you post your code maybe we can be more specific. -- Jim Rech Excel MVP |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| "search" a different sheet with multiple criteria | Excel Worksheet Functions | |||
| Returning a text string after a 2 criteria search | Excel Discussion (Misc queries) | |||
| to search for a string and affect data if it finds the string? | Excel Worksheet Functions | |||
| How do I search excel spreadsheets using multiple search criteria. | Excel Worksheet Functions | |||
| Search string with multiple criteria | Excel Worksheet Functions | |||
Linear Mode
