I'm trying to create a section in my macro that will copy the contents of cell AE2 (which will contain a formula) into the remaining cells of column AE (AE3 through whatever) that have data in another column ©. However, the last cell in column AE changes depending upon the file I use, so the last rown is not always the same number.
I was able to edit the macro so that it copies to the entire column (all 1,048,576 cells). But this is way too much. I don't want it to copy the formula to every cell in a column, but rather every cell in a column AE that has data column C.
Any suggestions would be appreciated.