Dim sh as Worksheet
set sh = Worksheets.Add(after:=Worksheets(worksheets.count) )

is how you add a worksheet
--
Regards,
Tom Ogilvy


"Len" wrote:

I have a worksheet with 243 Columns. I have a Macro that analyzes data from
a fare number of columns.

I just want to create a new worksheet with just the 21 columns I need to
print a mail merge document from.

All my code is working except I cannot find out how to create the worksheet
in the macro and then display the merge form letters. I have seen other
people do this several years ago, so I know it can be done.

A little green, only the third time I have worked with Excel, I am a real
time Macro Assembler Programmer.

Thanks in Advance

Len