Hi,
This is the first time that I post a question in this forum. I need to copy and paste a formula into a certain range of cells in column B (Number depends on how many non blank cells are there in column A). Simply copy and paste the formula into the whole column B will take too much time for Excel to work in the back end. How to do this in a macro? Thanks!!