+ Reply to Thread
Results 1 to 4 of 4

Relative reference not working when using macros

  1. #1
    Registered User
    Join Date
    06-09-2014
    Posts
    3

    Relative reference not working when using macros

    First time user.

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,885

    Re: Relative reference not working when using macros

    Welcome. We look forward to your participation.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Registered User
    Join Date
    06-09-2014
    Posts
    3

    Re: Relative reference not working when using macros

    Yes, I tried that. What I'm trying to do is delete a row of chosen cells (form is locked) then return back to the first cell below the deleted row. What's happening is that it's returning back to the cell chosen while writing the macro (which is at the very top). So if I'm several rows below the top of the form, it deletes the row and then returns all the way back to the top of the form causing the user to have to scroll back down to where they were.

  4. #4
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,885

    Re: Relative reference not working when using macros

    Suggest you post your issue in the macro/vba subforum. You have posted in the introductions forum which is not displayed under new posts.

+ 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. [SOLVED] relative reference not working
    By Zealotwraith in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-25-2013, 03:37 PM
  2. using relative reference in macros
    By ilundy77 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-04-2010, 04:39 PM
  3. $ Relative Reference not Working
    By mcball22 in forum Excel General
    Replies: 3
    Last Post: 12-22-2006, 01:56 PM
  4. Relative Reference Help Macros
    By PhillipsHQ in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-18-2006, 10:35 AM
  5. Replies: 1
    Last Post: 05-27-2005, 10:05 AM

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