Quote Originally Posted by Howardc View Post
I have a macro to clear data from Row 2 onwards in Col A, Col C to I and Col L to O. However, when activating the macro, the data to the right of Col O is also being cleared, which should not be cleared

Your assistance in resolving this will be most appreciated
The "data" in Columns P and T that you say are being cleared are actually not being "cleared"... the cells in those columns contain formulas which rely on data being in Column A... the formulas remain, but are set to display the empty text string ("") when the corresponding cell in Column A are blank (which is what your code line is doing). Are you sure you wanted to include Column A in the cells that you are clearing???