Problem with creating some hyperlinks

[YasserKhalil]

Hello everyone
I have devised the following code to create sheets based on range and after that create hyperlinks to these sheets
The code works fine and the sheets are created ..
As for hyperlinks there is a strange beaviour : some are very good and others gives me a popup "Reference is not valid" ..
I noticed that these hyperlinks have space and after removing space it works fine after testing the code

And the weird is that if I created hyperlink manually there is no error with the space ....

How can I overcome the space problem in the code??

Please Login or Register  to view this content.

Another point if possible .. How can I add a hyperlink in the created sheets to Sheet1?
Thanks advanced

[skywriter]

Try this.
Not sure it will make a difference, but it's worth a try.

Please Login or Register  to view this content.

[YasserKhalil]

Very wonderful Mr. Bruce. It really solves this weird problem .. may be the Arabic sheet names were the cause of the problem
But it is solved with your modification
Thank you very much

What about second point .. I need to add in M1 in created sheets a hyperlink to sheet1?