Posted to microsoft.public.excel.programming

Louise

external usenet poster

Posts: 217

If column contains a value - Error Trap

Hi,

I am trying to apply some error trapping to my code now.

I want to say that if a value (e.g. "Test") does not appear in Column A then
carry on, otherwise if it does appear in Column A (on any row) then an error
message pops up.

Can this be done, and how?

Thanks,

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Set Error handling INSIDE error-trap	Michelle	Excel Programming	6	May 3rd 08 03:30 PM
Need error trap	GregR	Excel Programming	4	June 14th 07 08:28 PM
Error Handling - On Error GoTo doesn't trap error successfully	David	Excel Programming	9	February 16th 06 05:59 PM
Error Trap	Kirk P.	Excel Programming	2	September 8th 05 09:51 PM

All times are GMT +1. The time now is 06:40 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us