range(inputbox("enter cell address ie: c21"))=0
However, there is probably a better way. Post your macro
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"jhong" wrote in message
...
Hi,


I have a macro that loops and stops until cells = 0 condition is meet.
Everytime i run this macro i do manually input zero to the range where
macro will run. My question is, can i create a macro that will put
zero to a specified range?


Thanks in advance!!


jhong