Copy Sheet to END of Workbook USing VB

[HotNumbers]

How do I copy a sheet to end of workbook? using VB

Currently I have this

Sheets("GL1I3CURR").Copy after:=Sheets(38)

However I always want this to be copied at the end since it gets regenerated everytime in another place of the code.

 

[JackDanIce]

Try:

Sheets("GL1I3CURR").Copy after:=Sheets.Count

 

[HotNumbers]

Getting Error

Copy Method of workshet class failed

 

[JackDanIce]

Apologies, missed out a word, try:

Sheets("GL1I3CURR").Copy after:=Sheets(Sheets.Count)

 

[HotNumbers]

PERFECT!!!!

Thanks for the quick reply.

 

[JackDanIce]

You're welcome, glad it works