Victor Moss
Board Regular
- Joined
- May 3, 2014
- Messages
- 90
Hi Guys,
I have 2 separate ranges, A5:G6000 & N5:Q6000, when I clear contents of all cells in a row in one range, not only some, I'd like the cells in the same row in the other range to be cleared. I know it's a Worksheet_Change event as I have a couple in my Sheet already, but I don't know how to code this one.
Any help would be appreciated.
I have 2 separate ranges, A5:G6000 & N5:Q6000, when I clear contents of all cells in a row in one range, not only some, I'd like the cells in the same row in the other range to be cleared. I know it's a Worksheet_Change event as I have a couple in my Sheet already, but I don't know how to code this one.
Any help would be appreciated.