Thread
:
How can I see column headings of hidden columns in Excel before u.
View Single Post
#
2
Don Guillett
Posts: n/a
assuming you have your name in row 1 of the column, you could use MATCH or
in vba you could use FIND
Sub findcol()
Columns(Rows(1).Find("yournamehere").Column).Hidde n = False
End Sub
--
Don Guillett
SalesAid Software
"Beachcomber" wrote in message
...
I have a large spreadsheet with several columns hidden. I want to unhide
a
specific column that I know has a column name of Project Owner. How can I
determine which column to unhide to see the desired column without
unhiding
all of the columns? I tried the find feature, but that did not help.
Reply With Quote