How to set active sheet in vba?

Asked by Mélody

Report
in progress 31
17 Answers 152 views

Leave a reply to Mélody : set active sheet in vba


Answers ( 17 )

  1. Excel VBA Introduction Part 5 - Selecting Cells (Range, Cells, Activecell, End, Offset) :

    how to set active sheet in vba

    Ratings : 70 %   

      
  2. Copying a set of data using Current Region :

    how to set active sheet in vba

    Ratings : 24 %   

      
  3. Sommaire→Excel→Feuilles. Quelles différences entre Sheet et Worksheet ? Je n'obtiens pas les propriétés et méthodes de l'objet ActiveSheet !
    Read More

    Ratings : 48 %   

      
  4. I want to have/define a unique id for each data row in my Excel data sheet - such that I can use it when passing the data onwards and it stays the same when rows are
    Read More

    Ratings : 37 %   

      
  5. I set up a sheet as you described with Zoom at 100. Print Preview indicated 14 pages for me (I already had selected Landscape). I manually change to Fit to 1 page
    Read More

    Ratings : 57 %   

      
  6. How to Email Your Current Workbook in Excel VBA :

    how to set active sheet in vba

    Ratings : 40 %   

      
  7. I am stuck with an excel problem and I need your help. While trying to insert an image in to my excel 2007 workbook using VBA I hit on this weird error and not
    Read More

    Ratings : 57 %   

      
  8. Excel VBA Introduction Part 6 - Worksheets, Charts and Sheets :

    how to set active sheet in vba

    Ratings : 36 %   

      
  9. MS Excel - Highlight Active Cell Using VBA :

    how to set active sheet in vba

    Ratings : 17 %   

      
  10. We can export the data from Microsoft Excel to Microsoft Access by using VBA. Below is the VBA code and process which you need to paste in the code module of
    Read More

    Ratings : 37 %   

      
  11. How to Put Data in Specific Sheets and Not on Active sheet :

    how to set active sheet in vba

    Ratings : 36 %   

      
  12. How to Make a Comparative Pie Chart in Excel with VBA :

    how to set active sheet in vba

    Ratings : 61 %   

      
  13. VBA 1 16 ActiveSheet, Cell, Workbook :

    how to set active sheet in vba

    Ratings : 50 %   

      
  14. Excel VBA Basics #7 - Using specific sheets, Hiding, Unhiding and Selecting with VBA :

    how to set active sheet in vba

    Ratings : 48 %   

      
  15. Excel VBA Events #5 Worksheet Activate-Select sheet, type age, inputbox puts it in bottom cell :

    how to set active sheet in vba

    Ratings : 29 %   

      
  16. Microsoft Excel VBA Worksheet Activate and Change Events :

    how to set active sheet in vba

    Ratings : 65 %