Thread: Identify cells with a value (excluding formulas)
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Dark_Templar
 
Posts: n/a
Default Identify cells with a value (excluding formulas)

Wrote:
Or, if you want to know which have values, but not formulas, Edit menu
/ GoTo / Special / check Constants, then check Numbers.

ed

Thats it - but I need it dznamic..as function.


--
Dark_Templar
------------------------------------------------------------------------
Dark_Templar's Profile: http://www.excelforum.com/member.php...o&userid=33279
View this thread: http://www.excelforum.com/showthread...hreadid=541235

Reply With QuoteReply With Quote