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