View Single Post
  #6   Report Post  
Old December 9th 04, 03:16 PM
Don Guillett
 
Posts: n/a
Default

try again

--
Don Guillett
SalesAid Software

"Beachcomber" wrote in message
...
Already tried that!

"Don Guillett" wrote:

Have a look in HELP index for MATCH.


--
Don Guillett
SalesAid Software

"Beachcomber" wrote in message
...
Your answer looks like it will work, but I have to admit I don't know

what
to
enter to use the MATCH function. I placed my cursor in a blank cell

and
typed =MATCH (Project Owner). I received an error message of #Name?

Thanks for your reply.

"Don Guillett" wrote:

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.