Code to hide Rows

**Excelski** · 05-13-2018, 04:44 AM

Hi,

I have 2 charts, one in Columns J:T and one in V:AF

I always want one showing and one hidden depending on the cell value G:1, either 1 or Zero

Can someone help me with some code, please

Kevin

**Excelski** · 05-13-2018, 04:57 AM

Sorry i posted in the wrong section, thanks for moving me!

**bakerman2** · 05-13-2018, 05:02 AM

Something to start with.
In Sheet module.

Private Sub Worksheet_Change(ByVal Target As Range)
    If Target = vbNullString Then Exit Sub
    If Target.Address = "$G$1" Then
        Select Case Target.Value
            Case 0
                Columns("J:T").Hidden = True
                Columns("V:AF").Hidden = False
            Case 1
               Columns("V:AF").Hidden = True
               Columns("J:T").Hidden = False
        End Select
    End If
End Sub

**Excelski** · 05-13-2018, 05:28 AM

Thank you.......I have entered the code into a module

When I try to run it the macro box opens asking for a name?, naming it just opens another module

What am i doing wrong?

**bakerman2** · 05-13-2018, 07:05 PM

Not just A module. You must pu this into the sheet module of the Chart sheet.

To do so right click on chart sheet tab and select View Code. Paste the code in the right window.

**Excelski** · 05-14-2018, 03:07 AM

Okay.....Got it
Thanks

**bakerman2** · 05-14-2018, 04:10 PM

Glad to help and thanks for rep+.

Code to hide Rows

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Code to hide Rows

Re: Code to hide Rows

Re: Code to hide Rows

Re: Code to hide Rows

Re: Code to hide Rows

Re: Code to hide Rows

Re: Code to hide Rows

Thread Information

Users Browsing this Thread

Similar Threads

VBA code to hide rows and for Vlookup

code to hide specific rows

[SOLVED] Code to hide rows

code for hide rows

Code to Hide and Unhide Rows

Code to hide rows

Code to hide rows = 0

Bookmarks

Bookmarks

Posting Permissions