reverts

  1. MFish

    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...
  2. 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
  3. 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...
  4. 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...

Some videos you may like

This Week's Hot Topics

Top