Hi all!

I have a strange behaviour in Excel: I cannot calculate values either in Excel worksheet nor by VBA. If I have a new workbook with 2 Sheets. Sheet1 is empty, sheet2 has a button linked to the code:
Sheets(1).Cells(1,1).Select
The error 1004 comes up. "Selection method or range class method failed".

The code:
Sheets(2).Cells(1,1).Select
works fine.

I Need EXCEL VBA for my work. Can anyone suggest what's wrong?

Just to mention it: macro security settings are low, VBA trust is on.
Workbook/worksheet properties are at default setting with EnableSelection on.

At a loss,

Andrew