Sheet Objects and Range Objects are not, and cannot be made equivalent.

You can return a range object consisting of all cells on a sheet with

Sheets("Sheet1").Cells



In article ,
NutoVBA wrote:

Do you have any ideas on how to identify a sheet as a Range?