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.
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.Please Login or Register to view this content.
Thanks in advance, also, Happy Thanksgiving (I know it's over now but still)
Bookmarks