Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using a popup to affect a column of numbers
Hi All I need to solve a problem , and would grateful if anyone can help. I need to input a number via a popup. Then increase all numbers in a column to the number entered in the popup. The numbers to apply the code to would already be selected in the wb. For example , if I entered the number 3 in the popup , all numbers equal to or below 3 would be increased to 3. All those above would stay the same. Example : Before : 1 2 3 4 5 6 After 3 3 3 4 5 6 Can someone help with some code? Grateful or any assistance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automating change via popup to a column of numbers | Excel Worksheet Functions | |||
How does 1 value affect the average? | Excel Worksheet Functions | |||
How do business loans affect the p & l? | Excel Discussion (Misc queries) | |||
How do i make a change in one worksheet affect the others | Excel Worksheet Functions | |||
Does font affect indent spacing? | Excel Worksheet Functions |