hide/unhide row

  1. D

    Macro to Hide Certain Rows with the Click of a Button, and other Rows with the Click of Another Button?

    Hello, I have a spreadsheet that is broken into costs for Canada and for the US. I don't know much about Macros, but am hoping to use a macro to hide all the rows that relate to an American cost when you click a button that might say "Canada" for example. And I'm hoping to have another button...
  2. W

    Macro to automatically update

    Hello, This is a long post, if you are too lazy, here is the issue. Need to make automatic changes to cells that will activate a "Run when Values Change Macro" without going into a loop forever. Getting "The object invoked has disconnected from...." when I've tried to link it I've got a job...
  3. M

    Auo Hide/Unhide Rows Using Macro

    Hello All, I am working on a spreadsheet "B" in excel and I need to be able to hide/ unhide rows that dont have a value in them.( The rows are linked to another sheet "A" in the workbook) I would like to be able to have the rows in sheet "B"unhide when I enter information into my table on sheet...
  4. S

    Help! Alter macro to automatically hide/unhide

    I have this macro that adjust lines accordingly to the # chosen in the drop down box (using data validation). Private Sub Worksheet_Change(ByVal Target As Range) Dim r As Long If Not Intersect(Target, Range("d1")) Is Nothing Then Range("A10:A1793").EntireRow.Hidden = True r...

Some videos you may like

This Week's Hot Topics