Putting zero value within a specified range, help please...

  • Thread starter Thread starter jhong
  • Start date Start date
J

jhong

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
 
range(inputbox("enter cell address ie: c21"))=0
However, there is probably a better way. Post your macro
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Highlight cells greater than zero 6
selecting data for a chart based on specific criterie 2
Running a Macro when a value in a range of cell changes 10
Help needed to writing a macro to put the year in column B of a tableusing Table nomenclature & the 7
Update this macro to make it generate a counter as text 7
Substituting zero values in blank cells 5
Conditional Format Excel 2007 2
Please help! 3

Back
Top