C
Colin Hayes
Hi
I need some help with some code.
I need a small macro which will look down a column and find the lowest
number. Then via popup , will ask for a new number to be input and will
then replace the lowest number with the input number.
For example ,
Before
3.50
3.50
4.50
4.50
3.50
6.50
8.50
3.50
After : (Number input to popup - 2.50)
2.50
2.50
4.50
4.50
2.50
6.50
8.50
2.50
So effectively , the number entered in the popup replaces the lowest
number in the column.
Can someone help with this?
Grateful for any assistance.
I need some help with some code.
I need a small macro which will look down a column and find the lowest
number. Then via popup , will ask for a new number to be input and will
then replace the lowest number with the input number.
For example ,
Before
3.50
3.50
4.50
4.50
3.50
6.50
8.50
3.50
After : (Number input to popup - 2.50)
2.50
2.50
4.50
4.50
2.50
6.50
8.50
2.50
So effectively , the number entered in the popup replaces the lowest
number in the column.
Can someone help with this?
Grateful for any assistance.