Finding values in hidden cells?
 

Hi!

I have problems when using the Find-method on Range-object if the valu
I'm looking for is included in hidden columns or rows. I am though quit
sure I have done this before in other sheets without problems. Now I'
like the values doesn't exist. I hide the columns in Excel mai
window.

Why does this work only sometimes? Or is not possible?

Thanks,
Davi

--
dfredriksso
-----------------------------------------------------------------------
dfredriksson's Profile: http://www.excelforum.com/member.php...fo&userid=2338
View this thread: http://www.excelforum.com/showthread.php?threadid=39461

Finding values in hidden cells?
 

You need to have it look in Formulas rather than Values. See the argument
options in help on the Find method in VBA help.

--
Regards,
Tom Ogilvy


"dfredriksson"
wrote in message
news:dfredriksson.1tk0b2_1123686550.6549@excelforu m-nospam.com...

Hi!

I have problems when using the Find-method on Range-object if the value
I'm looking for is included in hidden columns or rows. I am though quite
sure I have done this before in other sheets without problems. Now I's
like the values doesn't exist. I hide the columns in Excel main
window.

Why does this work only sometimes? Or is not possible?

Thanks,
David


--
dfredriksson
------------------------------------------------------------------------
dfredriksson's Profile:
http://www.excelforum.com/member.php...o&userid=23389
View this thread: http://www.excelforum.com/showthread...hreadid=394614