+ Reply to Thread
Results 1 to 2 of 2

VBA Relative Cell Reference and Loop until end of data

  1. 12-12-2019, 03:30 PM #1
    krissysteen
    krissysteen is offline
    Registered User
    Join Date
    01-25-2018
    Location
    Michigan
    MS-Off Ver
    Microsoft 365 MSO (Version 2308 Build 16.0.16731.20496)
    Posts
    30

    VBA Relative Cell Reference and Loop until end of data

    How can I take this macro I recorded and change to use relative cell reference in place of hard coded "Range" and loop until end of data. The actual document has 10x more data.
    My File is attached. I want to take Step 2 and create Step 3 Auto-Magically!
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by Leith Ross; 12-12-2019 at 05:15 PM. Reason: Added Code Tags
    Reply With QuoteRegister To Reply
  2. 12-12-2019, 05:28 PM #2
    maras_mak
    maras_mak is offline
    Valued Forum Contributor
    Join Date
    07-14-2017
    Location
    Poland
    MS-Off Ver
    Office 2010
    Posts
    528

    Re: VBA Relative Cell Reference and Loop until end of data

    Hi, does this do what you want?
    HTML Code: 
    Last edited by maras_mak; 12-12-2019 at 05:34 PM.
    Best Regards,
    Maras.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Copy and paste relative data with loop
    By MeggieDoodles in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-21-2017, 04:01 PM
  2. relative cell reference not working
    By c.vaibhav in forum Excel General
    Replies: 8
    Last Post: 09-03-2013, 10:22 AM
  3. Relative cell reference does not work
    By rjraymond in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 01-24-2013, 10:57 AM
  4. [SOLVED] Relative cell reference
    By Karnik in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-16-2012, 08:47 PM
  5. Using relative cell locations to copy in loop?
    By mpkavanagh in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-16-2011, 07:02 PM
  6. [SOLVED] Relative Cell Reference
    By Keith in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-10-2006, 12:39 AM
  7. How to reference a relative cell
    By eugeneg in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-04-2005, 06:53 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1