Macro to delete part of a row based on cell value vba

[BobBrown]

Hi All
I need to be able to delete a section of a row based on a the value in column E however I have formula's in column's F&G that I want to retain.

Macro to delete part of a row based on cell value vba.JPG

I was originally deleting the entire row with the below macro but have since added formula to the other 2 column's and cant figure out how to modify the macro to delete A:E while keeping F&G

Please Login or Register  to view this content.

Any help appreciated

[karmapala]

I was originally deleting the entire row with the below macro
but have since added formula to the other 2 column's and cant figure out how to

I'm sorry as I don't understand your bold sentence,
because I've run your code in your example workbook,
the result I think it's OK and the formula in the other 2 column still there.

Or do you mean you want to change the formula completely ?

On the other hand, if you only delete the cell on column A to E only,
the formula next to it gone wrong, it gives the result

Please Login or Register  to view this content.

[BobBrown]

Hi Karmapala
Thanks your reply. I didn't think that one through very well at all and should have done a bit more testing before posting. As you have indicated deleting part of the row is going to break the prepopulated formula. I am importing columns A to E form another sheet so the simple fix is to delete the rows of data based on a the value in column E before importing.
Thanks again for you reply.

[Logit]

.

Please Login or Register  to view this content.

[jindon]

BobBrown,

AutoFilter would be better.

Please Login or Register  to view this content.