I am looking to fill a formula down a column using a macro. I tried to just to the record a macro but my problem is that I get a different size list of numbers each time, so that will not work.

The formula is a nested replace =REPLACE(REPLACE(A2,4,0,"."),8,0,".") -- where the original number sits in A2 - It adds two periods to form a phone number.

I am having an issue finding out how to fill down to the last number present in column A. I had it filling till like 10k but that is ridiculous if there is only 50 or so lines.

Please help!

Thank you.