Forum Discussion
JamesPhImp
Aug 03, 2023Copper Contributor
VBA to check the date in column A, if its more than 40 days in the past then hardcode that line
Hi, I have a spreadsheet and would like a VBA code that checks the date that will be in column A, if the value of that date is older than 40days then it hardcodes that entire row (ie removes formula...
HansVogelaar
Aug 03, 2023MVP
Are the dates sorted in ascending (or descending) order?
If not, would it be OK to sort the data on the date column?