can I "lock" range values -

[Dave Wheeler]

hi folks

thanks for previous help with the "round" formula
but am still trying to put finishing touches to worksheet "calculator"

no manual input - all values set by "spin buttons"
information then copied/pasted to ranges - 4 active cells with values in each range
from spin button cells
all 4 cols set out - ITEM - VALUE - INTEREST CHRG - ADMIN COSTS
so would like to set up
rows for each item with col values as above

everything works fine but, as you would guess, all column values
linked to "buttons" so all rows showing SAME vales in each column

I don.t know how to isolate or freeze the values so that each row would show the respective column values for each item I want to record

I have tried a few "doubleclick/change/savebefore" procedures
but, being honest, I'm relatively new, but learning ( and humble )

any advice on this gratefully accepted
thanks as always

 

[VoG]

Not being a mind reader I would appreciate a link to your earlier thread(s) and the code that you are using