Auto selection of previous sheet in workbook using a macro

[Chris22]

Hi guys,

Im new here and also new to VBA.

I have a workbook with various worksheets. I have a macro that copies the latest sheet (active) and places it after itself...if that makes sense. That works fine.

What I need to do now is write a macro that selects a range from the "previous" sheet and copies/pastes into into the latest sheet.

I cant find a command that selects the previous sheet....any clues ..??

Regards,

Chris22

 

[RobBroekhuis]

Before you copy the sheet, make sure to remember it:

dim Sh as worksheet
set Sh=activesheet
activesheet.copy .... (make sheet called Newsheet)
sheets("newsheet&quot.activate
Sh.range("A1:Z10&quot.copy range("A2&quot

the final statement copies a range from your old sheet to the new one.

Rob

 

[Chris22]

Rob,

Maybe just me, but I could not get that to work...

Thanks anyway

Regards,

Chris

 

[RobBroekhuis]

I'm sure I can help you if you tell me at what point it doesn't work. If you copied what I suggested verbatim, you'll need to complete the ... For example:

dim Sh as worksheet
set Sh=activesheet
activesheet.copy
activesheet.name="NewSheet"
Sh.range("A1:Z10&quot.copy range("A2&quot

Does that help?
Rob