Repetition code with variables

Morning Folks

Could do with some help on this one...

I have the following code...

Discount = Range("Prelimdiscount").Value
total = Range("prelimtotal").Value
finalprice = total - (total * Discount)
Range("prelimtotal").Value = finalprice

...which runs at the press of a button embed into the spreadsheet.

The thing is i need the same code to run on about 10-15 different ranges, all with different names (prelimdisount etc.)

is there anyway of repeating this code without having to type it out 10-15 times for each individual name range?

I could be being very lazy here, so please tell me!!

TVM

Not unless there's logic in how the cells are located, consistently so many apart etc.

There's also no need to assign the values to variables:

Please Login or Register  to view this content.