Thread: simple excel macro Q
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Carim[_3_] Carim[_3_] is offline
external usenet poster
  
Posts: 137
Default simple excel macro Q
Hi,

There is no need for a macro ...
place yourself in cell E1 and input
=if($A$1<"",0,"")
and copy the formula all the way to column S ...

HTH
Cheers
Carim

Reply With QuoteReply With Quote