I need to create a new sheet in my macro. So far the code I've been using
looks something like this:

Dim sheet7 as worksheet
sheet7 = new worksheet

But I keep getting error saying that the object doesn't support automation.
I'm still a new programmer and I'm not sure what automation is. I can't seem
to find any documentation to tell me what I'm doing wrong.