brianfosterblack
Active Member
- Joined
- Nov 1, 2011
- Messages
- 251
My macro is stepping through the dates in column D from row 130 downwards. If it hits a date that the year of the date is less than the year recorded in a cell on another worksheet (MasterIB5). it must delete the contents as well as the contents in the same row in column C. The year entered in Master!B5 is in a cell formatted as General
I have tried this with code I currently have but simply cannot get it right.
Can anyone please assist.
I have tried this with code I currently have but simply cannot get it right.
Can anyone please assist.