copying sheet moving end

[smiley0q0]

i need to copy a sheet called "blank" and put it after all the other sheets. i need this in vba code, and i will be running this macro every month so the last sheet will change every month, so i can't tell it to put it after any particular sheet. Is there any code that tells it to put the copy after all the other sheets?

Thank you for your help

Smiley :-D

 

[JVFriederick]

Give this a go.

LastSheetNumber = Sheets.Count
Sheets("Blank&quot.Move After:=Sheets(LastSheetNumber)

 

[smiley0q0]

Great! works perfectly. Thank you.

 

[JVFriederick]