View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.misc
Sloth
 
Posts: n/a
Default automatically hide row if cell contains asterisk

Sorry for the late reply. A1 is the header of the column you are looking for
the asterisks in. If you are searching for asterisks in column C, then
change A1 to C1. Also, you might want to doublecheck that you are putting
the code under "ThisWorkbook" and not under any of the sheets or modules.

"djarcadian" wrote:


It doesn't seem to work for me. Is the "range" supposed to be just A1 or
do I put something like A1:G100?


--
djarcadian
------------------------------------------------------------------------
djarcadian's Profile: http://www.excelforum.com/member.php...o&userid=15877
View this thread: http://www.excelforum.com/showthread...hreadid=513775