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
Attachment 29011
Printable View
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
Attachment 29011
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.Quote:
how may i write the above 3 codes?
Much more likely to get useful suggestions
Use the instructions in my signature to get started