H
HowOnEarthDoI
Hi,
I am trying to write a macro that checks each row for a specific text in a
column.
If it does not contain the text, I want to hide the row.
....BUT only if checkbox1 is checked (true).
I thought it would be something like the below, but I don't have it right....
I am doing this within a For...next loop.
If Cells(RowNumber, SearchColumn) <> "*SPECIFIC TEXT*" And CheckBox1
= True Then
'Select row
Rows(RowNumber).Select
'Hide row
Selection.EntireRow.Hidden = True
Any help appreciated.
Thanks.
I am trying to write a macro that checks each row for a specific text in a
column.
If it does not contain the text, I want to hide the row.
....BUT only if checkbox1 is checked (true).
I thought it would be something like the below, but I don't have it right....
I am doing this within a For...next loop.
If Cells(RowNumber, SearchColumn) <> "*SPECIFIC TEXT*" And CheckBox1
= True Then
'Select row
Rows(RowNumber).Select
'Hide row
Selection.EntireRow.Hidden = True
Any help appreciated.
Thanks.