Move selected sheets to different workbook

[DeeEmmEss]

I have a simple problem that I cannot solve. A VBA routine I run daily creates a workbook (Book1) which I have declared as wb2 and imports sheets from various sources, manipulates certain data, renames the sheets, then selects all sheets. This works well and has done so for many nonths. I then wish to move all these selected sheets to the end of another open workbook (which I have declared wb1, currently RRAugust22.xlsm - but changes each month, always with RR prefix), but am having difficulty doing so. I currently transfer them manually with move/copy command, and then have another routine which further manipulates the data. I am trying with wb2.SelectedSheets.Move after:=wb1.Sheets.Count but cannot get it to work. Please ease my frustration.

 

[rlv01]

wb2.SelectedSheets.Move after:=wb1.Sheets.Count

wb2 is a workbook object consisting of properties and methods. "SelectedSheets" is not a valid property or method of the worksheet object. Recommend that you use the macro recorder and record yourself manually performing the action you want, then inspect the VBA code in the recorded macro to learn what the proper syntax should be.

 

[DeeEmmEss]

Aaahh that's why it won't work! Thankyou for your help riv01.