Visual Basic Excel Macro HALP

Off-topic forum which is now, paradoxically, the on-topic forum. Any on-topic posts will be moved to the off-topic forum and verse-vica.

Moderator: Moderators

Visual Basic Excel Macro HALP

Postby Mur » Sun May 16, 2010 8:42 am

Ello guys. So, is anyone here Excel savvy?

Trying to make a macro that finds all the columns with "point" in their header and hide them.

Sub Hideallpoints2()
Dim Rng As Range
For Each Rng In Sheets("Data").Range("a1:gg1")
If Rng.EntireColumn.Hidden = False Then
If Rng.Value = "point" Then
Sheets("data").Columns(Rng.Column).EntireColumn.Hidden = True
End If
End If
Next
End Sub

^- This does nothing.
More like murlurk.
User avatar
Mur
 
Posts: 565
Joined: Thu Nov 16, 2006 2:47 pm
Location: England.

Return to The Fast and the Spurious

Who is online

Users browsing this forum: No registered users and 5 guests