Thread: Interesting macro needed
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
excelbeginner excelbeginner is offline
external usenet poster
  
Posts: 1
Default Interesting macro needed

I need help creating a macro in excel that will fill Cols E - S with th
number zero for each row that has text in Col A.

something like this:

IF there is text in Cell A1 THEN fill Cells E1-S1 with zeros
IF there is text in Cell A2 THEN fill Cells E2-S2 with zeros
... Until the Cell in Col A that has no text

thank you

--
excelbeginne
-----------------------------------------------------------------------
excelbeginner's Profile: http://www.excelforum.com/member.php...fo&userid=3222
View this thread: http://www.excelforum.com/showthread.php?threadid=52979

Reply With QuoteReply With Quote