anthony20069
10-07-2008, 08:06 AM
Hi guys,
Need some help please....
I have the following code:
Sheets(1).name = "Workflow_" & Worksheets(1).Range("Project").Value
If the Range Project + the wording Workflow_ is longer than 31 Char, i would like the sheet name to have the following:
Workflow_[partofthename]...(with those dots- looks nice :) )
Cant figure out how to trim in VBA.
Thanks for your help
Regards
Anthony
Need some help please....
I have the following code:
Sheets(1).name = "Workflow_" & Worksheets(1).Range("Project").Value
If the Range Project + the wording Workflow_ is longer than 31 Char, i would like the sheet name to have the following:
Workflow_[partofthename]...(with those dots- looks nice :) )
Cant figure out how to trim in VBA.
Thanks for your help
Regards
Anthony