Remove the values if find in 3 column's "00-01-1900 or 0"

**johnodys** · 04-08-2014, 02:45 AM

Dear Expert

I want vba code help on 3 column if values contains like either "00-01-1900 or 0" remove those values in particular column result should be blank

Z:Z,AB:AB & AC:AC.....

find the attachment...

**zbor** · 04-08-2014, 02:53 AM

Try this:

Please Login or Register  to view this content.

**johnodys** · 04-08-2014, 02:59 AM

Thank You Sir It works perfectly!!! Solved

Remove the values if find in 3 column's "00-01-1900 or 0"

LinkBack

Thread Tools

Rate This Thread

Display

Remove the values if find in 3 column's "00-01-1900 or 0"

Re: Remove the values if find in 3 column's "00-01-1900 or 0"

Re: Remove the values if find in 3 column's "00-01-1900 or 0"

Thread Information

Users Browsing this Thread

Similar Threads

Advanced filter when column values are "True" and "False"

[SOLVED] If there is any text in column "A$" on "sheet1" then move cell to column "A$" on "sheet2"

[SOLVED] Find "X" in range of cells and return various values based on the column "X" is found in.

[SOLVED] Formula needed to display "Pass" or "Fail" if a column contains any values other than "yes

Help Needed to get Filters Using "Include" and "Exclude" multiple values on one column.

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions