LinkBack URL
About LinkBacks
Hi,
Probably because you are still using the Sheets(X) syntax.
Remember we had to change this in the line that added the new sheet since X is not a string variabe. So wherever you have Sheets(X) substitute
Replace(CStr(X), ":", " ")
Hi,
Probably because you are still using the Sheets(X) syntax.
Remember we had to change this in the line that added the new sheet since X is not a string variabe. So wherever you have Sheets(X) substitute
Replace(CStr(X), ":", " ")
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Hi Richard,
Thank you so much for your input and suggestions. It finally works like I wanted it to work. Actually I had to replace the "X" in Sheets(X) with Replace(CStr(X),":"," ")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks