Hi there,
Long time lurker, but have finally come up against a brick wall. I'm sure it's a simple solution that I can't work out!
Here's my code:-
Now, the problem is that the row number within the range is always changing, so my B67:FE67, could easily be B99:FE99, so I'm manually editing it each time. I'm sure there's a way it could be done so that this changes automatically, but I don't know how?!
I have one constant that will always be the bottom row that has the data in that it checks to see if it's below 200 and that is "grand total"
Any ideas anyone?
Long time lurker, but have finally come up against a brick wall. I'm sure it's a simple solution that I can't work out!
Here's my code:-
Code:
Sub RemoveColumns()
For Each c In Range("B67:fe67")
If c.Value < 200 Then
c.EntireColumn.Hidden = True
Else
c.EntireColumn.Hidden = False
End If
Next
End Sub
Now, the problem is that the row number within the range is always changing, so my B67:FE67, could easily be B99:FE99, so I'm manually editing it each time. I'm sure there's a way it could be done so that this changes automatically, but I don't know how?!
I have one constant that will always be the bottom row that has the data in that it checks to see if it's below 200 and that is "grand total"
Any ideas anyone?