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 |
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 |
simple excel macro Q
Thank you for your reply. I would still like to use a macro b/c I will be doing this very often and it would expedite the process. If you know how to write such a macro, that would be a great help. Thanks again, Excelbeginner -- excelbeginner ------------------------------------------------------------------------ excelbeginner's Profile: http://www.excelforum.com/member.php...o&userid=32228 View this thread: http://www.excelforum.com/showthread...hreadid=519781 |
All times are GMT +1. The time now is 09:41 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com