=proper

[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.

 

[Harlan Grove]

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.

If you mean you recorded a macro and it doesn't work when you try to run it,
it's very likely because you recorded the macro with absolute references, so
it always tries to perform its actions on the same column no matter which
column you select.

Either way, if you want help with macros, SHOW US YOUR MACRO CODE. Nothing
is less possible than trying to figure out what's wrong with YOUR macro code
if YOU won't share it.