Define contents entire worksheet

This is probably a very easy question to answer (at least, I hope so...), but could anyone tell me how to define the contents of an entire worksheet, regardless of what's in that worksheet? I thought it would be something like below, but that's not working.

wsContent = Worksheets("wsName").Value

Thanks!

Thanks for the quick reply, but I still get an error for this line saying Subscript out of range. Do you have any idea how to solve this?

You may not have a sheet name called "wsName" in one of your sheets. Make sure the sheet you are working does not have typo and space.

The code was copied directly from here, only the sheet name has been changed to reflect the name of the actual sheet. There are no differences in the sheet name.

you could use

Please Login or Register  to view this content.

Did you define wsContent? It has to be a variant

To answer both of you here: wsContent has been defined as Object (not entirely sure if that's correct?). wsName is the name of the actual worksheet, it's not a variable. i can't use ActiveSheet as it isn't the sheet that's active at the moment.

Remove the object, so leave wsContent with out any varaible

wsContent is a Range Object. Try:

Please Login or Register  to view this content.

Guys, I got it working. It turned out that earlier in the macro a different worksheet was opened which was active at the moment. Thanks for the suggestions, I think I was asleep yesterday...