Need to fill a Sheet by "paint by click" (Double-click toggle value)

[Foxcastle]

I need a method so that when I double click on a cell, it inserts a value. My range is A1:CB2400.

I found the following code that almost does what I want, but only for a single column (B) and only if there are values in the adjacent column (A), and I'm not savvy enough to figure out how to extend it. This is basically what I need, just for every cell in my range, without the dependency on other cells.

Please Login or Register  to view this content.

Any help is very much appreciated. Thanks!

[shg]

Please Login or Register  to view this content.

[Foxcastle]

Perfect! Thank you!

[shg]

You're welcome.