Skip down to the TLDR section to get it working a.s.a.p. Please read the Security section — it explains a 100x slowdown that catches almost everyone the first time.

There are rare cases where you want to edit all cells. Generally, you would write this using row and column loops, wouldn't you? Sub EditCell() Dim r As Long Dim c As Long For r = 1 To ...

We're one of the leading tech book publishers in the UK. We have published 7k+ books, videos, articles, and tutorials. When dealing with VBA for Excel, you'd be forgiven for thinking that your code ...