+ Reply to Thread
Results 1 to 2 of 2

Range selection-row of data

  1. #1
    Registered User
    Join Date
    06-24-2005
    Posts
    11

    Range selection-row of data

    I'm trying to select a row of data, and am having trouble. I have a search that finds the row I want (it will change depending on the data). Now I want it to select the first 15 cells of that row so I can copy it to another sheet. Example, Row 20 has the data I want, and I want it to select A20-O15. This is what I have tried so far:

    Range(ActiveCell,Offset(0,15).Select

    This is one example and I know it isn't right, but it gives the idea of what I'm trying to do.

  2. #2
    Forum Contributor
    Join Date
    07-07-2005
    Location
    England
    MS-Off Ver
    Office 2019 Enterprise
    Posts
    473
    If the current cell was A1 then using this formula would highlight/select the range A1:J1.


    Selection.Resize(Selection.Rows.Count, Selection.Columns.Count + 9).Select

    hope this points you in the right direction

    John

+ 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