Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I've been struggling for a day now in trying to write a macro that will
cycle through all the worksheets in a workbook, then check each column for the word "HIDE" in a certain row (15) in each column, then if it finds it, hides the column. e.g.(with a bit of psudo code thrown in :-( For I = 1 To Worksheets.Count ActiveWorkbook.Worksheets(I).Select For Each col In Worksheets(I).Columns if row 15 = "HIDE" Then Column(col).Select Selection.EntireColumn.Hidden = True Next col Next I've tried most things, but my VBA skills are not yet good enough to manage this. Any help anybody?? Please?? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Automtacally change entry based on value in column. | Excel Worksheet Functions | |||
Automating to autofill column B based on column A entry | Excel Discussion (Misc queries) | |||
restricting entry into a cell based on entry to a previous cell | New Users to Excel | |||
Auto entry of data based on entry of text in another column or fie | Excel Discussion (Misc queries) | |||
Help tonight?!! select rows based on cell value in a column | Excel Worksheet Functions |