+ Reply to Thread
Results 1 to 11 of 11

Selecting from firstrow to lastrow of data

  1. 06-30-2011, 03:45 AM #1
    uncleslinky
    uncleslinky is offline
    Forum Contributor
    Join Date
    04-06-2009
    Location
    England
    MS-Off Ver
    Excel 2007
    Posts
    103

    Selecting from firstrow to lastrow of data

    Hi,

    I have a table of data, which will often change in length. I have defined the first row of and last row of data as:

    firstrow
    lastrow

    Is there a way to select these two rows as well as everything in between?

    Thanks
    Last edited by uncleslinky; 06-30-2011 at 05:14 AM.
    Reply With QuoteRegister To Reply
  2. 06-30-2011, 03:49 AM #2
    docMed
    docMed is offline
    Registered User
    Join Date
    06-29-2011
    Location
    California
    MS-Off Ver
    Excel 2003/2007
    Posts
    58

    Re: Selecting from firstrow to lastrow of data

    Why do you need to select them? Typically there is a vba command that can reference those cells easily then execute the property adjustments you'd like.
    Reply With QuoteRegister To Reply
  3. 06-30-2011, 04:09 AM #3
    uncleslinky
    uncleslinky is offline
    Forum Contributor
    Join Date
    04-06-2009
    Location
    England
    MS-Off Ver
    Excel 2007
    Posts
    103

    Re: Selecting from firstrow to lastrow of data

    I need to paste special values, however I do not want to select the entire worksheet. I only want to paste special values within that range.
    Reply With QuoteRegister To Reply
  4. 06-30-2011, 04:14 AM #4
    romperstomper
    romperstomper is offline
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    England
    MS-Off Ver
    365, varying versions/builds
    Posts
    21,971

    Re: Selecting from firstrow to lastrow of data

    If those two are actually named ranges:
    Please Login or Register  to view this content.
    or if you are pasting from elsewhere:
    Please Login or Register  to view this content.
    Everyone who confuses correlation and causation ends up dead.
    Reply With QuoteRegister To Reply
  5. 06-30-2011, 04:23 AM #5
    uncleslinky
    uncleslinky is offline
    Forum Contributor
    Join Date
    04-06-2009
    Location
    England
    MS-Off Ver
    Excel 2007
    Posts
    103

    Re: Selecting from firstrow to lastrow of data

    Hi guys,

    Apologies for the confusion. I meant to say I declared lastrow and firstrow as variables (not named ranges. Is my request still possible?

    I'm quite new to VBA so again apologies for any confusion
    Reply With QuoteRegister To Reply
  6. 06-30-2011, 04:29 AM #6
    romperstomper
    romperstomper is offline
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    England
    MS-Off Ver
    365, varying versions/builds
    Posts
    21,971

    Re: Selecting from firstrow to lastrow of data

    How are they declared and what values do they have?
    Reply With QuoteRegister To Reply
  7. 06-30-2011, 04:33 AM #7
    uncleslinky
    uncleslinky is offline
    Forum Contributor
    Join Date
    04-06-2009
    Location
    England
    MS-Off Ver
    Excel 2007
    Posts
    103

    Re: Selecting from firstrow to lastrow of data

    firstrow is always row 4
    lastrow will be set my a user input box


    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  8. 06-30-2011, 04:35 AM #8
    romperstomper
    romperstomper is offline
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    England
    MS-Off Ver
    365, varying versions/builds
    Posts
    21,971

    Re: Selecting from firstrow to lastrow of data

    Is the number of columns fixed? If so, which ones are they?
    Reply With QuoteRegister To Reply
  9. 06-30-2011, 04:43 AM #9
    uncleslinky
    uncleslinky is offline
    Forum Contributor
    Join Date
    04-06-2009
    Location
    England
    MS-Off Ver
    Excel 2007
    Posts
    103

    Re: Selecting from firstrow to lastrow of data

    Yes, columns A:AT
    Reply With QuoteRegister To Reply
  10. 06-30-2011, 04:45 AM #10
    romperstomper
    romperstomper is offline
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    England
    MS-Off Ver
    365, varying versions/builds
    Posts
    21,971

    Re: Selecting from firstrow to lastrow of data 

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  11. 06-30-2011, 05:13 AM #11
    uncleslinky
    uncleslinky is offline
    Forum Contributor
    Join Date
    04-06-2009
    Location
    England
    MS-Off Ver
    Excel 2007
    Posts
    103

    Re: Selecting from firstrow to lastrow of data

    Thanks :-D
    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)

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