Save Macro - Avoid errors when /'s are present

I have a save macro that saves the file and uses a value in a cell for the filename. Sometimes this value may have a / in it.

How can I modify this to prevent error? The solution I thought of is to have another cell = this particular cell and replace /'s with spaces...and then use that value for saving instead..but there may be an in vba code solution I am not aware of.

Please Login or Register  to view this content.

For reference C11 and C30 are part numbers that are generally numbers with dashes, but occasionally have a / in them which is what of course throws the error.

Thanks in advance, also, Happy Thanksgiving (I know it's over now but still)

That simple.... I am dumb.

Thank you.

Originally Posted by sintek

Not at all...just needed a fresh set of eyes...
Tx for rep +

Haha right on. My eyes are not fresh after Thanksgiving..was a busy one and not much sleep! Works perfect thanks again and you're welcome