+ Reply to Thread
Results 1 to 2 of 2

How to select the active cell in this VBA

  1. #1
    Registered User
    Join Date
    06-18-2019
    Location
    Europe
    MS-Off Ver
    2016
    Posts
    2

    How to select the active cell in this VBA

    I've made a sheet "Plan" with data and a corresponding sheet that's meant for printing "Printable Report" (with only the important info in it).
    From time to time I want to insert new rows (data) in my sheet "Plan".
    In the following macro the active cell in sheet "Printable Report" is not the corresponding active cell in sheet "Plan", unless I manually activate the corresponding cell.
    So the inserted row in sheet "Printable Report" happens on the place where the cell was selected last time.
    For example, cell C75 (row 75) was activated last time in sheet "Printable Report".
    And now I want to insert a new row 24 between the current rows 23 en 24 in sheet "Plan".
    With this macro the new inserted row in sheet "Printable Report" will take place in row 75 which is of course not correct...


    How can I select the corresponding cell from the other sheet?

    Using offset ?



    Please Login or Register  to view this content.
    Last edited by seba_93; 06-20-2019 at 01:25 AM.

  2. #2
    Valued Forum Contributor
    Join Date
    12-14-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2007
    Posts
    439

    Re: How to select the active cell (in sheet 1) in this VBA

    Please use [CODE] tags for code.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. VBA Code to select active cell when on any sheet. For filtering.
    By Crawfy in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-05-2019, 08:49 PM
  2. (Urgent Req) VBA code required to select a sheet just before a active sheet
    By mchilapur in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-10-2015, 12:03 PM
  3. [SOLVED] syntax to select cell in another sheet based on offset of active cell in current sheet
    By duvius in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-07-2014, 11:16 AM
  4. [SOLVED] How to select sheet before the active one
    By drrazor in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-30-2014, 06:46 AM
  5. Replies: 1
    Last Post: 07-08-2012, 08:47 AM
  6. VBA - Can I select a new active cell based on the value of the current active cell?
    By GrumpyOldBastard in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-08-2012, 07:05 PM
  7. [SOLVED] Copy from active sheet and paste into new sheet using info from cell in active
    By Ingve in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-23-2006, 06:00 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1