Hello,

I have two different ranges in worksheet3 which you can select with
option button.
By selecting option button 1 it shows values of range1 in worksheet1,
and by selecting option button 2 it shows values of range2 in
worksheet1. Values are shown in same range in worksheet1, and
everything goes ok this far.

The promblem is that values won't update to worksheet1 without
selecting first another option button.

ie. if option button 1 is selected it shows values in worksheets1&3,
but after changing some of the values in range1 I have to select option
button 2 and again option button 1 to update the values in worksheet1.

I've tried some if-thens but just can't get it to work, any ideas...?

Regars, Mardo