amend macro to select all but last column of data

[MichPr]

Hi, I'm a newbie to all this but I have the following macro - it works ok and selects all the data in spreadsheet and converts to Proper Case

However I also need a macro to select all except the last column of data and convert all except the last column to Proper Case.
It is for Post / Zip code info. so wish to keep it in Upper Case.

What I have already is:

Please Login or Register  to view this content.

I was hoping I could easily amend the above to select all except last column.
Any help would be greatly appreciated.

Thank you

[alansidman]

Code Tags Added
Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between

Please Login or Register  to view this content.

tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found at http://www.excelforum.com/forum-rule...rum-rules.html



(Because you are new to the forum, I have added them for you today. Please take a few minutes to read all Forum Rules and comply in the future.)

[alansidman]

Try this code.

Please Login or Register  to view this content.

[MichPr]

Thank you.
I get an error at the following line

Please Login or Register  to view this content.

[alansidman]

Please supply a sample worksheet to test code with. When you ran debug, what was the error message?

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic