Results 1 to 2 of 2

Excel 2013 - VB 7.1 - Macro for moving "one cell" down reports System Error & H80010108

Threaded View

  1. #1
    Registered User
    Join Date
    11-28-2012
    Location
    Slovenia
    MS-Off Ver
    Excel 2013
    Posts
    2

    Smile Excel 2013 - VB 7.1 - Macro for moving "one cell" down reports System Error & H80010108

    Hello to Excel forum.

    I mostly read solutions and collect some good ideas from Excelforum :-)

    However, I have one issue with code bellow:

    Sub move_selection_down()
        Dim rOriginalSelection As Range
        Set rOriginalSelection = ActiveCell.Offset
        With rOriginalSelection
            .Select
            .Cut
            .Offset(rOriginalSelection.Rows.Count + 1, 0).Select
        End With
        Selection.Insert
        rOriginalSelection.Select
    End Sub
    When I check in debbuger it stops at point .Offset(rOriginalSelection.Rows.Count + 1, 0).Select.

    Q: How I reproduced error message?

    A: If I open excel file it works just fine and I can easily move cell value down.
    However, once I change focus to another column and put some data to another cell and return back to desired cell to use again macro I get an error.

    I put you an example of Excel screen:
    You can see button and code of macro for that object. On left side is "red" marked cell I can move down. It Works fine till the moment I put any value in excell, if I return back to button than I get an error.

    http://shrani.si/f/1S/Ij/4IPhU4n3/screen.png

    To be honest, I'm not expert in programming. It seems excel or "macro is lost" when I abort to use down function for another work with data.

    Thank you for any suggestion on that matter.

    Matej
    Last edited by astra; 09-26-2016 at 05:37 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Optimal System Requirements for Excel 2013
    By lugburz in forum Excel General
    Replies: 7
    Last Post: 12-08-2015, 11:04 AM
  2. System requirements for Excel 2013
    By lugburz in forum Excel General
    Replies: 0
    Last Post: 12-08-2015, 04:53 AM
  3. Upgrade to Excel 2013 - Macro error 'the object invoked has discon....'
    By craigp46 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-18-2015, 06:26 PM
  4. Replies: 3
    Last Post: 07-20-2014, 11:46 AM
  5. MACRO ERROR WITH EXCEL 2013 - Run-Time Error '-2147417848 (80010108)'
    By graiggoriz in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-29-2014, 11:07 AM
  6. System Error &H80010108 (-2147417848) object invoked disconnected client
    By xclrInTraining in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-30-2013, 10:14 AM
  7. Windows 8, Excel 2013 and Project 2010 - Reference Error in Macro
    By microsoftexcel007 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-01-2013, 06:23 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