making the previous ws active in excel

Hot Topic

Installing Business Scorecard Manager 2005 on a SQL Server 2005 instance.
empty datagrid
VBA Debug
BUNDLING MS MONEY 07 TRIAL
Automatically send attachment in email with a submit command button in word
Problem: Macro not deleting columns I select
Runtime error '13' - type mismatch problem! Again...
vba create and add a macro for excel programmatically
Outputting to a Listbox
Running a macro if new mail if from a specific address

Microsoft ISV

i want a code for file transfer by ws2_32.dll library
vlookup
Completly Lost with Data Validation Code
Dimensions in BSM
Inserting additional chars into a string....
VSTA support
break text lines in msgbox a meassage
MS Access & Windows Media Player
worksheet_change and data validation
Error handling problem

making the previous ws active in excel

Hi,

I'm copying cells on one worksheet and paste them into another ws. After being paste I once again want my macro to view the first ws. How can I do this

Maybe this example explain it better:

Activesheet.select

x = selection ' x = should be the activesheet

copy

bla bla bla

Sheets("2").Select

Paste

bla bla bla

Sheets("x").Select

Any ideas

\Jonas




Answer this question

making the previous ws active in excel

  • Dave Jenkins

    Hi

    If you mean worksheet then the below is what you need, if you mean workbook the principle is similar

    Dim ws As Worksheet
    Set ws = ActiveSheet

    ws.Activate

  • xuyca

    Perfect!

    Thank you!

    \Jonas



  • making the previous ws active in excel
Answer this question