Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Sep 2013
    Posts
    11
    Thanks
    4
    Thanked 0 Times in 0 Posts

    How to copy rows in range and paste to new sheet

    hi everyone,

    hoping you can help me figure out this problem

    how to copy rows in the range (between the rows that are starting with a specific text and ending with a specific text ) and paste in a new sheet.
    actually we dont know the range.

    ie i have a excel sheet with information on rows.

    for example:

    MEMBER INFORMATION
    ..........
    ........
    .......
    .............
    so on

    ************ END OF DATA FROM INTERNAL STORAGE ************

    how to copy and pate the middel rows in between these 2 above texts to new sheet in the same workbook with specified name?

    please guide me

    gvg

  2. #2
    New Lounger
    Join Date
    Sep 2013
    Posts
    11
    Thanks
    4
    Thanked 0 Times in 0 Posts
    hi

    for above problem

    i am getting the address of the starting text MEMBER INFORMATION

    for example i am getting the address of the text is $A$1345
    i am passing this to a string( strtext = $A$1345)
    can we use this string in the range like range (strtext:A2000)
    is it correct or wrong
    please guide me

  3. #3
    WS Lounge VIP
    Join Date
    Dec 2009
    Location
    Earth
    Posts
    8,197
    Thanks
    48
    Thanked 986 Times in 916 Posts
    See your existing post for an answer.

    cheers, Paul

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •