Microsoft Excel 2003 (full product)
April 22, 2010 at 09:27:35
Specs: WIndows XP Profesional Version 2002 Service Pack 3, Intel Pentium 4 3.40GHz / 1.GB RAM
Hi I am a newbie to VBA and floundering a little.

I am using Excel 2003. And I am trying to write a bit of code that extracts certain information from a data Worksheet first by finding the relevant character String then copying the data i need. The Problem i have is that the data sheet will not always find that data and i want to stop it erroring each time it is run and not there. I presume i also need an IF query but not quite sure how to write the code.

Please Help


See More: NULL FIND code

Report •

April 22, 2010 at 11:00:57
Re-post this in the programming forum.

Report •

April 22, 2010 at 13:58:05
edit your macro code and insert (right before the "find" op):
on error resume next
and if you want error-trapping disabled after the find op:
on error goto 0

Report •

Related Solutions

Ask Question