In this morning's routine, I worked on Practical Application Part 3 of VBA, referring to Ken Yoshida's book. Once again, I used Chapter 1 of Ken Yoshida's book as a reference. However, rather than ...
I learned the For Next loop. The example in the book worked. I was confident. "I'll make a macro to delete all blank rows." That's what I thought when I wrote it. For i = 1 To 100 If Cells(i, 1).Value ...
If you can write an Excel formula, you can build your own function.