Notifications
Clear all
VBA & Macros
3
Posts
2
Users
0
Reactions
175
Views
Topic starter
I have a column of cells that I'd like to edit one cell at a time.
I want to edit the cell; multiply the contents by a number that is contained in a one cell range name, round the result to two places, calculate the cell (i.e. make it a value). Lastly, I want the macro to move down to the cell below.
Anyone know a relatively simple way to address this?
Posted : 13/02/2018 4:29 pm
Hi Chris
See if this helps.
Enter a value in the yellow cells and it will multiply with the value from the range named RATE and then it will round to 2 decimal place.
Sunny
Posted : 14/02/2018 12:05 am
Topic starter
Thanks Sunny,
I think that will work.
Posted : 14/02/2018 3:48 pm
