How to limit characters in a .Range command?

[kbackous]

Still refining this bit of code;

Please Login or Register  to view this content.

This runs great except when the total characters exceed 31 (limiting length of a tab name). My value that resides in "B2" I have found often will exceed this so I want to revise the code to only grab the first 25 characters of this cell. I have tried using the Left command but it doesn't seem to work, operator error no doubt...

Any help, as always, is greatly appreciated.

[jeffreybrown]

Untested try...

Please Login or Register  to view this content.

[kbackous]

Untested try...

Please Login or Register  to view this content.

Works perfectly, thanks!