trying to understand why a code is not working "error 9 subscript out off range"

ok with help from this forum i created this code to insert a date in one sheet

Please Login or Register  to view this content.

this works fine if I put on a new workbook but it produces an error on the workbook where i'm trying to implement.

having said that i found a workable solution as follows

Please Login or Register  to view this content.

but i'm quite frustrated that i don't understand why the first code is not working
i would appreciate if someone have a look on my workbook and could check where the problem lies.

the error which give me is "error 9 subscript out off range"
all the code is in module 6 and is to insert a date on sheet(Ex11.5) cell b3.

Originally Posted by tehneXus

There is no "sheet2" in your workbook, adapt the following line to the worksheet you want to write to:

Please Login or Register  to view this content.

e.g.

Please Login or Register  to view this content.

sheet2 is represent sheet "EX11.5" i have tried what your solution but no luck!

"subscript out off range" usually means the worksheet you are referencing does not exist. In the attached there is not sheet called ("sheet2").

thanks all for the help the coin has dropped I'm off the dark.

the solution was the bloody space I had it like this ("Ex11.5") and should be like this (" Ex11.5")

Am i correct to say that the sheet as been named with a blank space before the name?