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


I need help creating a macro in excel that will fill Cols E - S with the
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,

excelbeginner


--
excelbeginner
------------------------------------------------------------------------
excelbeginner's Profile: http://www.excelforum.com/member.php...o&userid=32228
View this thread: http://www.excelforum.com/showthread...hreadid=519781