Hello,
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.
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.