How to hide a row if it contains N/A, what type of formula would work with that? So far I have 86 rows and about 20 columns...
How to hide a row if it contains N/A, what type of formula would work with that? So far I have 86 rows and about 20 columns...
Can a filter work?
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."
Already have filters trying to automatically do it at a keystroke when prompted
Please see code in post #3
Hi Solus,
I have tried using your code and modified for Columns. Getting an error Invalid use of Me keyword. Did I do something wrong?
Please Login or Register to view this content.
The code needs to be placed in the worksheet module for the sheet it applies to, not a stand alone module or workbook module.
To navigate to the worksheet module, right click the tab of the worksheet you would like to use to macro on and click 'View Code'. Paste the code there.
Perfect!! Thank you!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks