+ Reply to Thread
Results 1 to 6 of 6

Starting point

  1. 06-04-2016, 04:32 PM #1
    Phyxius
    Phyxius is offline
    Registered User
    Join Date
    02-17-2014
    Location
    Netherlands
    MS-Off Ver
    Excel 2010
    Posts
    14

    Starting point

    How to alter this macro so that it will start from the selected cell instead of from A3.

    Thanks in advance.


    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  2. 06-04-2016, 04:38 PM #2
    shg
    shg is offline
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    Re: Starting point

    It does start with the selected cell:

    Please Login or Register  to view this content.
    Entia non sunt multiplicanda sine necessitate
    Reply With QuoteRegister To Reply
  3. 06-04-2016, 06:11 PM #3
    Phyxius
    Phyxius is offline
    Registered User
    Join Date
    02-17-2014
    Location
    Netherlands
    MS-Off Ver
    Excel 2010
    Posts
    14
    I see what you mean but it does not.
    Example:
    When I select cell H1 and execute the macro it will go to A3 and start from there.
    Reply With QuoteRegister To Reply
  4. 06-04-2016, 06:17 PM #4
    shg
    shg is offline
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    Re: Starting point

    Then the macro you posted is not the one that's running. Have you tried stepping through it?
    Last edited by shg; 06-04-2016 at 06:48 PM.
    Reply With QuoteRegister To Reply
  5. 06-05-2016, 02:44 PM #5
    Phyxius
    Phyxius is offline
    Registered User
    Join Date
    02-17-2014
    Location
    Netherlands
    MS-Off Ver
    Excel 2010
    Posts
    14

    Re: Starting point

    I am sorry to say that you are wrong, it is the macro I was using. I think you did not look further than the data valition query.
    Any why I figured it out and corrected it.
    Thanks any way.

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  6. 06-05-2016, 03:58 PM #6
    shg
    shg is offline
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    Re: Starting point

    I responded to the question you asked, which was ...

    Quote Originally Posted by Phyxius View Post
    How to alter this macro so that it will start from the selected cell instead of from A3.
    And it does.
    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. Starting Point
    By JT_2111 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 09-10-2014, 02:45 PM
  2. Index/Match to find Starting Point of Average, Ending Point of Average Variable
    By tgentry in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-09-2012, 01:04 AM
  3. Create a pareto chart with % line starting from top point of first data point
    By jeffreybrown in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 06-27-2011, 10:47 PM
  4. Starting Point For Form
    By markrennolds in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-23-2010, 05:34 PM
  5. Starting point
    By LouP in forum Excel General
    Replies: 1
    Last Post: 05-15-2008, 12:40 PM
  6. Go back to starting point
    By PeterW in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-16-2006, 08:57 AM
  7. Starting Point of macro
    By Turin in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-07-2005, 08: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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1