Replacing the lowest number with a popup input

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.
 

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

Top