| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Putting zero value within a specified range, help please...
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Putting zero value within a specified range, help please...
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| putting a name in the name box | Excel Discussion (Misc queries) | |||
| putting one name under another on a cell | Excel Discussion (Misc queries) | |||
| Putting | Excel Programming | |||
| putting range bars (MIN AND MAX) on a bar chart of medians | Charts and Charting in Excel | |||
| Putting Sheet Names in a range and renaming it? | Excel Worksheet Functions | |||
Linear Mode
