Hi Broogle,

I do not have the workbook I set up to test the code. I will do that
tomorrow and send you an update.

Alok Joshi

"broogle" wrote:

Hi Alok,

When I tried to insert USA between Canada and Germany, it only works
for Sheet2.ColumnB and the position of Sheet2.ColumnC remain the same,
all numbers didn't align with the changes. Could you please help me to
modife the macro.
Thanks a million.