Hello all.
I have a macro that when you run it, it saves the Excel file in a specific location.
The file name is taken from a specific cell that is filled by the user before running the macro.
The problem is, when the user insert specific characters in that cell, it stops the macro.
The characters are /\:*?"<> ... All the characters that are not acceptable in Excel file names.
My question is if there is a way to block the use of these characters inside cells?
Thanks in advance.
Copy and paste this macro into the worksheet code module. Do the following: right click the tab name for your sheet and click 'View Code'. Paste the macro into the empty code window that opens up. Change the range (in red) to the suit your needs. Close the code window to return to your sheet. Enter a value in A1 and press the RETURN key.
Please Login or Register to view this content.
You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
Practice makes perfect. I'm very far from perfect so I'm still practising.
I located a dialogue which inspects the worksheet for illegal characters, and fixes them before the macro runs. You might load it use a call() before your macro and it should flow.
https://www.excelcise.org/vba-functi...ers-in-string/
Pete
Lots of topics on this, here's one.
https://www.excelforum.com/excel-pro...s-or-name.html
Hi,
macro for multi-cell
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
,
Bookmarks