Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi, I am having trouble with writing a "find" code that will work. Here is
what I want to do: I need to search column A for "Account Category:" and call out a macro on that cell, then find the next instance and do the same. My worksheet is a few thousand lines so having an automated find function will make a HUGE difference! Part of the problem too is that the cells in question will always begin with "Account Category:" but may differ, like one will be "Account Category: 20512" and another might be "Account Category: 22265". I tried recording a macro while I used the find function, but it wouldn't work when I tried to run it. Suggestions are greatly appreciated! Thanks in advance |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Search / Find Function | Excel Worksheet Functions | |||
Find / Search Function | Excel Discussion (Misc queries) | |||
why is there no excel11.xlb file when I perform a search? | Excel Discussion (Misc queries) | |||
perform 1 function, stop, perform different function | Excel Discussion (Misc queries) | |||
Find & Search Function | Excel Worksheet Functions |