I'm not a VBA guy, but through other threads on here I've got my code working on the spreadsheet like we want it, with a hide/unhide, email function, and clear contents.
Now that its working there are a few nice to haves that I can't seem to crack, the worst of which is this.
I have it hiding rows based on what a user enters, or doesn't. So for example in Column A, if they don't enter order quantities for items in Rows 20-23, it hides them. This is just because the Excel is massive, and I've assigned a button so when they are done entering what they want to order, they click it and it collapses the whole thing by hiding all the empty rows. A Clear button undoes the hide, and clears the quantities they entered. Great.
But, there are four vendors, so there are header rows and subtotaling for money/tax etc that a user doesn't ever enter anything for in Column A, so they don't get hidden during this. The end result works for us, but its ugly to see a header bar and a couple of subtitle bars.
What I'm trying, and failing, is to say, if Range(A20:A23) has no quantities ( so under that vendor they've ordered nothing ) to hide the header and subtotal rows. So hide A16:A19 and A24:26. My Clear button should work to unhide them already.
Don't know why I can't get this to work. Any ideas? I'm sure its something obvious I've overlooked.
Bookmarks