Which sheet did I just add?

[docjohn52]

I'm writing a project that moves column data for an account to a dedicated sheet. If the account is new, I create a sheet.

How do I scan for the next new sheet.

NewSheet=sheets.add doesn't work. (Error 438.)

Thanks guys,

Upside down in VBA help, and I'm sooooo embarrassed!

John

 

[docjohn52]

Never mind...

Adding a new sheet makes it active...

John

(have a nice night...)

 

[combo]

Add method returns object, so:

[b]Set[/b] NewSheet=sheets.add

There are optional parameters: Before, After, Count and Type, that allow to precise what and where sheets are inserted without any relation to active sheet.

combo