loop + Add value

[tarenlg]

Hi everyone,

i have write a loop if a condition is met.
But i also want to change the blue circled item to
1) 10
2) clear content
3) 10/1/2021 <--date

how may i write the above 3 codes?

TIA

29011

[Paul_Hossler]

how may i write the above 3 codes?

I'd start by attaching a workbook with some data and the current macro so that others don't have to try and type it in from a tiny screen shot.

Much more likely to get useful suggestions

Use the instructions in my signature to get started