+ Reply to Thread
Results 1 to 7 of 7

Edit Macro to Select Range to Start List

  1. #1
    Forum Contributor
    Join Date
    07-06-2008
    Location
    NC
    Posts
    149

    Edit Macro to Select Range to Start List

    I wanted to change where the list started (A1) to another cell. I can't find where I can edit the code to do this (to something like B4)

    Here is the link:
    http://www.excelforum.com/excel-misc...ml#post1991279

    or here is the code
    HTML Code: 

  2. #2
    Forum Expert
    Join Date
    08-27-2008
    Location
    England
    MS-Off Ver
    2010
    Posts
    2,561
    Please Login or Register  to view this content.
    Change to start row

    Please Login or Register  to view this content.
    Change the 1 to 2 for B, 3 for C etc.

    HTH

  3. #3
    Forum Contributor
    Join Date
    07-06-2008
    Location
    NC
    Posts
    149

    Thank you

    works good. Can I Offset it to a lower row. Like 4 or 5??

  4. #4
    Forum Expert
    Join Date
    08-27-2008
    Location
    England
    MS-Off Ver
    2010
    Posts
    2,561
    hyper_i = 4

    hyper_i = 5

    I'm thinking this doesn't warrant code tags...

  5. #5
    Forum Contributor
    Join Date
    07-06-2008
    Location
    NC
    Posts
    149

    Again thanks

    Works nicely..let me play with it for an hour or so then if all works, close out the post.

  6. #6
    Forum Expert
    Join Date
    08-27-2008
    Location
    England
    MS-Off Ver
    2010
    Posts
    2,561
    Please mark your own thread as solved - the moderators have other things to do...

  7. #7
    Forum Contributor
    Join Date
    07-06-2008
    Location
    NC
    Posts
    149

    remove reference A1

    Sorry, one more question -

    Anyway to remove the !A1 (reference) on the items in the list and just leave the date??

    HTML Code: 

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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