Me Again
Ok... I have a worksheet change event that fires a username and date when a range of cells have been amended.
What I would like it to do is only to work when the row is populated.
So for example if row 1:5 is populated then the worksheet change event kicks in if row 6:10 is blank then the worksheet change event is disabled.
I'm trying to use:
With very little success but that could be because I don't know where to add it within the Worksheet_Change(ByVal Target As Range) code?
I've tried this with the help from Google:
But I get a runtime error 438. Object doesn't support this property or method
Any ideas?
Bookmarks