Hello,
I have a macro where I want to replace all empty cells in a range with a formula. Here is the code that I have currently:
However, this replacement method removes the relative cell referencing. I need "G14" in the IF statement to update to whichever row the empty cell is in. For example, if the empty cell is K20, I need the replacement formula to be this:Please Login or Register to view this content.
Cheers!Please Login or Register to view this content.
Bookmarks