RefEdit and choosing cells that aren't adjacent

Hello there.

I'm making a macro with a userform with several RefEdits. It's easy enough to let the RefEdit choose several adjacent cells (fx: E10, E11 and E12), but I don't know how to make it work with non-adjacent cells (fx: E10, E14 and E18).

The relevant code is this:

Please Login or Register  to view this content.

Above code works perfectly if I choose E10, E11 and E12, but not E10, E14 and E18.

Anyone has a solution to this?

Originally Posted by bakerman2

Did you try pressing Ctrl-key while selecting cells ?

Yes. I get to choose the different cells. It just doesn't work in the formula.

I get the error:

PHP Code: 

Run-time error '1004':

Method 'Range' of object '_Global' failed 


Then highlights:

Please Login or Register  to view this content.

Originally Posted by bakerman2

How about this.

Please Login or Register  to view this content.

This worked! Except I had to change the =average to =middel (native language). So my macro will only work in Danish Excel, I guess?

Originally Posted by bakerman2

This should translate correctly.

Please Login or Register  to view this content.

This worked. Thank you!