Code to create new sheet and rename, regardless of any other sheets in workbook

I've searched quite a bit, but can't find the exact answer I'm looking for.
I was wondering if anyone could provide the code for the following.
Create a new sheet and rename it 'FUTA Max"

I know that seems simple as this

Please Login or Register  to view this content.

BUT, this only works if the worksheet created = "Sheet 1". I get a debug error when there is already a Sheet 1 or any other Sheet # for that matter. Somtimes the new worksheet is Sheet 1, sometimes it is Sheet 7, etc..

I need the code that would create a sheet and rename it to "FUTA Max" no matter what sheets are already in the workbook.
I've seen many "almost" resolutions that would probably be easily coded to fit my situation, but I am a VBA newb and can't really manipulate other people's code. This is part of a larger macro, but that is the first part.

Thanks,

Thanks,

Try

Please Login or Register  to view this content.

Replace this line

Please Login or Register  to view this content.

with

Please Login or Register  to view this content.

Thanks you have solved the issue of my initial question, so I will label this thread closed.