Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
skiping sections in a macro
I am wanting to run a macro to find a certain string of text and I want it to
delete that text if it finds it. Is there any way that I can set it up where the macro will go to the next section if it does not find what it is looking for instead of erroring out? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
skiping sections in a macro
Yup, we can help you avoid the error... But post your code so we can see what
you are up to. -- HTH... Jim Thomlinson "Karrisac15" wrote: I am wanting to run a macro to find a certain string of text and I want it to delete that text if it finds it. Is there any way that I can set it up where the macro will go to the next section if it does not find what it is looking for instead of erroring out? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
skiping sections in a macro
dim FoundCell as range
set foundcell = something.find(....) if foundcell is nothing then 'do nothing else foundcell.entirerow.delete 'or whatever end if Notice that there won't be a .activate at the end of that .find(...) line. Karrisac15 wrote: I am wanting to run a macro to find a certain string of text and I want it to delete that text if it finds it. Is there any way that I can set it up where the macro will go to the next section if it does not find what it is looking for instead of erroring out? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Worksheet Sections | Excel Discussion (Misc queries) | |||
Worksheet Sections | Excel Discussion (Misc queries) | |||
sum by skiping one cell | Excel Discussion (Misc queries) | |||
use of sum by skiping one or more cells | Excel Discussion (Misc queries) | |||
use of sum by skiping one or more cells | Excel Discussion (Misc queries) |