reapply

  1. J

    Formatting all 1 as ✔ and all 0 as Blank (with vba ? )

    Hi, i have the following working directly on worksheet ✔;;;@ but the problem is when trying to reapply the formatting with VBA, as the tick isnt recognised. example, when i record myself applying the formatting, the output is: Range("A1:A23").NumberFormat = "?;;;@" Does anyone have a way...
  2. M

    Sorting data

    Hello, I would like to make the custom sort I have set "reapply" when I open, cloese, or save (any will work) the workbook. I currently need to click "reapply" in the sort menu to sort the data, but this spreadsheet will be used by everyone in the office eventually, so I would really like to...
  3. M

    Reapply Filter to Multiple Worksheets

    I have an Excel file with multiple worksheets that each have an autofilter applied to the same set of data. The filtered cells are pulling from data on another worksheet that I need to update regularly and have the worksheets with filters recalculate or reapply accordingly. Right now the...
  4. G

    Advanced filter refresh after data change

    I have an advanced filter in Excel 2002 (on Windows XP). I want to automatically refresh/reapply the filter when any of the data (aka "List Range") is changed. I've done a lot of searching and experimentation and I just can't find a good solution. Please let me know if you have any thoughts or...

Some videos you may like

This Week's Hot Topics

  • Timer in VBA - Stop, Start, Pause and Reset
    [CODE=vba][/CODE] Option Explicit Dim CmdStop As Boolean Dim Paused As Boolean Dim Start Dim TimerValue As Date Dim pausedTime As Date Sub...
  • how to updates multiple rows in muliselect listbox
    Hello everyone. I need help with below code. code is only chaning 1st row in mulitiselect list box. i know issue with code...
  • Delete Row from Table
    I am trying to delete a row from a table using VBA using a named range to find what I need to delete. My Range is finding the right cell. In the...
  • Assigning to a variable
    I have a for each block where I want to assign the value in column 5 of the found row to the variable Serv. [CODE=vba] For Each ws In...
  • Way to verify information
    Hi All, I don't know what to call this formula, and therefore can't search. I have a spreadsheet with information I want to reference...
  • Active Cell Address – Inactive Sheet
    How to use VBA to get the cell address of the active cell in an inactive worksheet and then place that cell address in a location on the current...
Top