B
Bobbie
Good Morning:
A vendor sent a workbook with several spreadsheet. Each spreadsheet has
hundreds of rows. I would like to change the all upper case he used to
proper. I used the =proper function and it works well. Here is my
problem. I tried to build a macro that whatever column I cliced on a
new column would be inserted, the =proper function would run all the
way down the column and then copy and paste the values over the column
that has the upper case. Since it worked without the macro, I was
surprised when the macro didn't work. I use Excel 2002 with XP.
Thank you for any help.
A vendor sent a workbook with several spreadsheet. Each spreadsheet has
hundreds of rows. I would like to change the all upper case he used to
proper. I used the =proper function and it works well. Here is my
problem. I tried to build a macro that whatever column I cliced on a
new column would be inserted, the =proper function would run all the
way down the column and then copy and paste the values over the column
that has the upper case. Since it worked without the macro, I was
surprised when the macro didn't work. I use Excel 2002 with XP.
Thank you for any help.