Zero Find And Delete

**jamer02** · 07-13-2011, 07:18 AM

Hey all,

I currently have this code:

Please Login or Register  to view this content.

Rather than deleting the entire row, I only want to delete the first three cells in that row.

Help would be greatly appreciated.

Thanks

Jamer

**mohd9876** · 07-13-2011, 07:22 AM

try this:

Please Login or Register  to view this content.

**StephenR** · 07-13-2011, 07:22 AM

If you mean cols BCD:

Please Login or Register  to view this content.

Use Clear instead of Delete if you just want to remove the cells' contents.

**jamer02** · 07-13-2011, 08:27 AM

No I mean cols ABC

Cheers

**mohd9876** · 07-13-2011, 08:28 AM

in that case:

Please Login or Register  to view this content.

**jamer02** · 07-13-2011, 08:34 AM

For some reason that is deleting colums BCD still :/

Any ideas?

**jamer02** · 07-13-2011, 08:35 AM

Actually, when I have another value in that row, it is moving that value accross.

Why is this do you think? And is there a solution?

**mohd9876** · 07-13-2011, 08:39 AM

you should use Clear instead of delete as StephenR said

Please Login or Register  to view this content.

Re: Zero Find And Delete