Hey anyone have a line of code I can throw into my macro to replace NA's with - in my Excel sheets?
Much appreciated
Hey anyone have a line of code I can throw into my macro to replace NA's with - in my Excel sheets?
Much appreciated
Is it limited to a certain column or row? Or literally accross the ENTIRE worksheet?
e/ This will do an entire sheet but it may be slower than reducing the scope just to the areas you want effected.
Please Login or Register to view this content.
Thanks,
Solus
Please remember the following:
1. Use [code] code tags [/code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.Highlight the code in your post and press the # button in the toolbar.2. Show appreciation to those who have helped you by clicking below their posts.
3. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.
"Slow is smooth, smooth is fast."
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks