Indexing Columns
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 7 of 7

Thread: Indexing Columns

  1. #1
    Board Regular
    Join Date
    Mar 2002
    Posts
    75
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    Here is my query. I will hopefully make some since here. WhatI am trying to do is write code that looks at another spread sheet and copies the values from a column range to another spreadsheet in a seperate workbook. I have code for most of this.

    The problem
    I need to copy a different column range for a given spreadsheet. I want to index that to a cell in the spreadsheet that the values are being copied into.

    IE: Estimate 1 The one being in its own cell telling the code to look in a given column on the other sheet. Is there a way to index a cell range by column? I know it can be done by row.

    Any help would be much appreciated. I have went through the search and have some ideas from there but nothing definitive.

    Thanks in advance
    Paul

  2. #2
    MrExcel MVP Al Chara's Avatar
    Join Date
    Feb 2002
    Location
    Newark, Delaware
    Posts
    1,701
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Not sure if I understand your query, but are you looking for worksheets("Sheet1").Columns(1).select, which will select column 1 on Sheet1?
    Best regards,
    Allan Chara
    http://www.mrspreadsheets.com

  3. #3
    Board Regular
    Join Date
    Mar 2002
    Posts
    75
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Al, yes that is what I am looking for, thank you. I can index what you have there to cell pretty easily. Now the problem is I don't need the entire column. Just a range from the column. Is there a command to add the to restrict the rows in the column?

    I am on the right path now. I will go do battle with the compiler.

  4. #4
    Board Regular
    Join Date
    Mar 2002
    Posts
    75
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    A little more info here. Here is what I am trying to do more specifically.

    I want to copy the cell range c6:c75 from one sheet to another, but when I open a new sheet I will need to index the new sheet to copy from the previous sheet I copied for to copy the cell range d6:d75 and so on down the line. As I mentiond before I think I can sucessfuly index the destiantion spread sheet through a cell in the sheet, my problem is the proper syntax for indexing a cell range like above. all the help so far has been much appreciated.

    Thanks, Paul

  5. #5
    MrExcel MVP Al Chara's Avatar
    Join Date
    Feb 2002
    Location
    Newark, Delaware
    Posts
    1,701
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Do you want something like the following:

    Intersect(Range(Rows(6), Rows(75)), Columns(3)).Select

    Best regards,
    Allan Chara
    http://www.mrspreadsheets.com

  6. #6
    Board Regular
    Join Date
    Mar 2002
    Posts
    75
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Al, That looks like what I need. I will plug it in and give it a try. Appreciate it. I wish I could find a place that has just syntax for the code. I have a book, but its about useless, This forum by far is the best resource I have found.

  7. #7
    MrExcel MVP Al Chara's Avatar
    Join Date
    Feb 2002
    Location
    Newark, Delaware
    Posts
    1,701
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Try the help files. They are a great resource. Use the microsoft online help too.
    Best regards,
    Allan Chara
    http://www.mrspreadsheets.com

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com