Livin404
Well-known Member
- Joined
- Jan 7, 2019
- Messages
- 743
- Office Version
- 365
- 2019
- Platform
- Windows
Greetings, I have the following Dynamic Set Print Area. I am hoping there is a way it can be protected or keep it from being compromised. It appears if we want select and delete the contents that also affects the print area. I just need my date to be cleared and have data pasted onto worksheet while keeping the Set Print Area and Conditional Formatting. Thank you
Excel Formula:
DynPrint=OFFSET(Duplicates!$A$1,0,0,COUNTA(Duplicates!$A:$A)+3,8)