I didn’t like the double click thing - it seems to work, but a double click anywhere would set it off - personal preference. If you like it, it seems to work (with blank cells all around)
The RestofCells was an attempt as a UDF but i didn’t get time to finishing it off, again if it’s not your thing we can try other stuff.
Personally i think, the code for the doubleclick thing is a decent starting point, but i would put it in the personal macro workbook so can i use it as and when then add to the QAT.
If you are basically happy with the doubleclick then we can update (with a button or QAT) to leave a formula and make it work with data around it?
Let me know
|