return to previous worksheet

I have a workbook in which I create invoices so I am frequently adding new worksheets (invoices). I have all my clients addresses in each worksheet and I use a macro to place the chosen address in a specific cell location on that worksheet. This means every worksheet I create carries the whole list of my clients

I have put the address list into a separate sheet, Sheet1 and hidden it. What I would like to do is call the address from Sheet1. Using the macro I can go to sheet1 unhide it, select and copy the information, but I cannot return to the previous sheet I was using to paste the information. All the methods I have tried end up with an error.

Can anyone help.

PW

Hi Norie
Thanks for the quick response I have renamed Sheet1, Ad.

Sub Claudia_Lesti()
'
' Claudia_Lesti Macro
'
Sheets("Ad").Visible = True 'Opens Addresses
'Sheets("Ad").Select
'
Range("M15:M20").Select
Selection.Copy 'Need to switch back to last used worksheet at this point
'ActiveSheet.Next.Select ' This switches back to previous sheet
'ActiveSheet.Previous.Select 'This switches back to new sheet
'LastSheet.Select
Range("A12").Select
ActiveSheet.Paste

Range("M22").Select 'will need to switch back to Ad worksheet at this point
Application.CutCopyMode = False
Selection.Copy 'Then return to last used worksheet at this point
Range("H21").Select
ActiveSheet.Paste
Range("B19").Select
Application.CutCopyMode = False
Range("A18").Select
ActiveWindow.ScrollRow = 11
Range("B19").Select
End Sub

Hi Norie

Thanks for your interest but after thinking about it a little more I found the solution. You gave me a clue when you said that I didn't have to unhide the sheet.

Thanks