Using ranges from different sheets in a subroutine

[Lanox]

Hello,

I have a subroutine "MATRIXCALC" that takes two matrices as input. I have predefined two ranges in excel: "Matrix1" and "Matrix2", but Matrix1 is located in sheet1 and Matrix2 in sheet2.

I would like to call this subroutine by a button placed on sheet1 with the following code:

Please Login or Register  to view this content.

If I run this code, I get the message "Method 'Range' of object '_Worksheet' failed".

Is there a way to call different ranges from different sheets?

Thank you!

[romperstomper]

Yes - specify the sheet:

Please Login or Register  to view this content.

[Lanox]

Solved.

Thanks romperstomper!