Hide Rows/Hide Columns Based on Value in Cell

[brickwall823]

Hello!

I am just getting started with VBA, and am trying to figure out two separate but related questions.

I was hoping to set up a macro that would let me

1) Show columns where cell in row 2 equals values in 1 of 3 cells on a separate worksheet. So if the value in row 2 of current worksheet = value of cell 1 or cell 2, or cell 3 on a different worksheet, then show the column, otherwise hide it. The values of cell 1, cell 2 and cell 3 are dynamic and will change.

on the same worksheet

2) Hide rows where cell in column I, equal "Inside", "Outside", "In-and-Out" and show the rest

Thank you so much for you help!

 

[Ray Huber]

this may get you started in the right direction

sub HidingMacro

if cells(2,1) <> Workbooks("OtherWorkbookName").Sheets("WhateverSheet").range(A1:A3) then
cells(2,1).columns.delete
end if

'part 2
for x = 1 to cells(rows.count,9).end(xlup).row

if cells(x,9) = "Inside" or "Outside" or "In-and-Out" then
cells(x,9).entirecolumn.hide
end if 

next

This code is pretty sloppy and it's 3AM where I am so there are probably a number of errors with this, but hopefully it at least gets you thinking in the right direction.

-Ray