+ Reply to Thread
Results 1 to 2 of 2

Activecell.offset and Merged Cells

  1. #1
    Registered User
    Join Date
    05-17-2010
    Location
    kent, England
    MS-Off Ver
    Excel 2003
    Posts
    11

    Activecell.offset and Merged Cells

    I use a Macro that will copy the contents of the activecell to the cell below it. The code is very simple and has worked for many years on all of my different templates.

    Please Login or Register  to view this content.
    My latest template requires rows to be merged and this is causing an issue. The macro works as expected, but when i use the left or right arrow key on my keyboard after running the macro, the wrong cell is selected.

    If i have a value in cell A1 that i want to appear in cell A3. The macro will copy the value to A3 and select cell A3. I then use the right arrow key on my keyboard to select cell B3 but cell B1 is selected instead. See gif below.
    200w_d (1).gif
    Last edited by Typicalalex1; 11-02-2017 at 05:45 AM.

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,619

    Re: Activecell.offset and Merged Cells

    Are you sure you have not written it this time as:
    Please Login or Register  to view this content.
    Asking because I could not obtain the same result as you presented on GIF (even using merged cells, which I usually try to avoid - we all know merged cell in excel is pleasant looking evil :-P
    Best Regards,

    Kaper

+ 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. Offset selection based on selected cells not just activecell
    By sabin348 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-28-2015, 12:20 PM
  2. [SOLVED] VBA ActiveCell Offset
    By hobbiton73 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-11-2013, 05:50 AM
  3. Select a Range of Cells Offset from a Selected Merged cell
    By kelvomatic in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-07-2013, 05:52 PM
  4. Function with "ActiveCell.Offset(x, y).value" not calculating cells automatically?
    By Skywalker in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-20-2011, 03:17 AM
  5. activecell.offset
    By steelsoul in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-17-2010, 09:23 AM
  6. Coding for offset cell references with multiple row headings with merged cells
    By AndyE in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 01-04-2010, 02:22 PM
  7. OFFSET/COUNTA merged cells
    By dborchardt in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-14-2006, 08:03 PM

Tags for this Thread

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