Messed up code :-/

**james 35** · 03-07-2013, 05:25 AM

Below is a code I've tried to alter the change values in certain cells in sheets with the same prefix to proper case ...

Can anyone advise where I've gone wrong ??

Thanks

James

Please Login or Register  to view this content.

**AB33** · 03-07-2013, 05:31 AM

Did you get an error, or the code does not work?

**james 35** · 03-07-2013, 05:46 AM

Yes the set rng line is where the debugger points to ?

james

**james 35** · 03-07-2013, 05:53 AM

just got this to work but it doesnt loop through all sheets ?

Please Login or Register  to view this content.

**Norie** · 03-07-2013, 06:02 AM

James

Try this.

Please Login or Register  to view this content.

**james 35** · 03-07-2013, 06:10 AM

That worked a treat Norie :-))))))))

Thank you

James

Originally Posted by Norie

James

Try this.

Please Login or Register  to view this content.

Messed up code :-/

LinkBack

Thread Tools

Rate This Thread

Display

Messed up code :-/

Re: Messed up code :-/

Re: Messed up code :-/

Re: Messed up code :-/

Re: Messed up code :-/

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions