Macro rto clear Data from where total value appears in Col A

[Howardc1001]

I have data on Sheet "Data"


I have tried to write code to clear data from where "Total value" appears to two rows below this and 6 columns to the right of where "Total value appears"


I cannot get my code to clear this data


It would be appreciated if someone could kindly assist me

Please Login or Register  to view this content.

I have attached sample data

[jindon]

Please Login or Register  to view this content.

[excel_newbie86]

You try:

Please Login or Register  to view this content.

[Howardc1001]

Thanks for the help Guys, much appreciated


Jindon what is the significance of ?

Please Login or Register  to view this content.

[jindon]

Range.Find method parameters

Find(What, After, LookIn, LookAt, SearchOrder, SearchDirection, MatchCase, MatchByte, SearchFormat)
Constant 1 for xlWhole, 2 for xlPart.
When names of the named arguments are omitted, you need to keep the order of parameters, so equivalent is

Please Login or Register  to view this content.

HTH

[Howardc1001]

Thanks for the explanation