Renaming duplicate column names

SUBHASHn · Dec 10th 2020

It is stopped near 2090 cell...in total I have 65k cells in the A column

dangelor · Dec 10th 2020

Code

Workbooks("C:\BP\Input.xlsx").Save

dangelor · Dec 10th 2020

Quote from SUBHASHn

It is stopped near 2090 cell...in total I have 65k cells in the A column

What stopped? Did the macro finish running?

SUBHASHn · Dec 10th 2020

Yes macro finished running at 2090

dangelor · Dec 10th 2020

Can't tell the players without a scorecard... As Mumps said earlier, post your workbook and code.

I ran the code on a test file of over 600K rows and 1 column. No problems. Run time was less than 3 seconds.

SUBHASHn · Dec 11th 2020

I don't disagree...It's strange... Thank You both?

Participate now!