Help with Macro that strips all lowercase letters

[bigbizz]

My worksheet in Column A, (A1-A151) contains sentences.
Column B-Z contains numbers followed by letters. Example: 45AcB

The Macro I created (below) is used to strip lower case letters from the entire sheet.
Is there a way to begin at Column B. Skipping Column A entirely.

This Macro strips all lowercase letters in all column and rows...

Please Login or Register  to view this content.

[Olly]

Hello

Let's see:

• Wrong forum.
• Cross posted from OzGrid.
• No CODE tags.

Other than that, perfect first post You may wish to read The Rules...

[alansidman]

Please read the rules, encase your code in code tags and post the cross posting

Please read this about crossposting: http://www.excelguru.ca/content.php?184

I have moved this thread to the appropriate forum.

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

[bigbizz]

Hi

The code works fine by stripping lower case letters but it starts at Column A and I would like to start at column B
That's why I asking for help.

[alansidman]

No one will respond to this thread until you edit your thread as requested and post the link to the other forum and add code tags. Please comply.

[bigbizz]

Hi
Thank for any assistance
is this what you speaking of when you asked me to edit with code tags?

Please Login or Register  to view this content.

[Olly]

Once more: You may wish to read The Rules...

[Leith Ross]

Hello bigbizz,

I have added the code tags for you since you are a new member. Please read my signature to learn how to add code tags to your post.