Windows 10 issue with Sheet placement

Hi,

I am currently working on upgrade to Windows 10 and seems to found issue with sheet name needs to be written before range/cells, however it seems to be intermittent.

For example below code is not working,

Please Login or Register  to view this content.

and have to be change to

Please Login or Register  to view this content.

However below code without Sheets(...) would work.

Please Login or Register  to view this content.

Can someone point out the changes made to Excel VBA in Windows 10?

Thanks
Lex

Hi,

This is not an issue with Windows10....
If you don't reference the sheet name, the value (or the formula) of the cell will be modified in the ACTIVE sheet when the macro is launched.
As a good practice, you should ALWAYS refer to the worksheet.. and even the workbook if you are working with multiple workbooks in your macro.

You could change your code to this :

Please Login or Register  to view this content.