Morning Hassan,

The Macro will not take "much time". It will cycle through two thousand rows and however many columns extremely quickly.

If you moved the Macro to a different file that has your "real" data, can you check which sheet number it is on? (not the worksheet name) and change the 'With Sheet1' to whatever. Or replace 'With Sheet1' to 'With Active sheet' and it will work.

Ochimus