I have a VBA code that is too long (after a certain point it stops working) and I'm hoping that there's a way to simplify it to fix this issue. What the code does is it replaces any empty cells in a given range with a default formula. Here is the code I'm currently using:
And so on...
So the formula is repeated for several columns in each section, then changes slightly for the next section:
But is there a way to simplify this formula so I don't necessarily need one section of code for each column since they all use basically the same formula? I've tried using "myCell.Column" for the column designation, but that doesn't seem to work. Any other suggestions?
Any advice would be greatly appreciated!
Bookmarks