-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
reverts
-
Resize columns through VBA
Hi, I am making a userform with checkboxes that will be a "Filter what you want to see" action. When you checkmark a checkbox it will then hide the designated column. When you uncheck it, it reverts back to unhide. My problem I have is it works great until you unhide the column and the...- MFish
- Thread
- checkboxes column reverts unhide width
- Replies: 1
- Forum: Excel Questions
-
R
How to stop 0% being a #DIV/0
So I'm just doing a simple formula of B1/A1 as a percentage. If B1 is 0 then the answer reverts to an error (#DIV/0). How do I get it to be BLANK if answer is zero? Please help - thanks in advance- RichardL4Y
- Thread
- #div/0 answer blank error reverts
- Replies: 7
- Forum: Excel Questions
-
E
VBA numberformat doesn't get saved
Hi guys I got a strange problem. Here is the code to change the columns into 'accounting' numberformat then tries to save and close the workbook. With ActiveSheet .Range("G:I,Q:T").NumberFormat = "_($* #,##0.00_);_($* (#,##0.00);_($* ""-""??_);_(@_)" End With ThisWorkbook.Save...- Eyeson15
- Thread
- numberformat reverts save saved workbook
- Replies: 3
- Forum: Excel Questions
-
T
date Picker custom format reverts to native format
...and I use the term "native" for want of a better term. I have a User Form with a MultiPage control. On different pages I have datePickers. The datePickers are set to a Format dtpCustom and the CustomFormat is "yyyy.MM.dd". This is the same for all the date pickers on all the multipages. In...- TorontoJim
- Thread
- datepicker formatting reverts
- Replies: 0
- Forum: Excel Questions
