Indexing Columns

kluitna · Apr 5th, 2002, 11:05 AM

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

Al Chara · Apr 5th, 2002, 11:22 AM

Not sure if I understand your query, but are you looking for worksheets("Sheet1").Columns(1).select, which will select column 1 on Sheet1?

kluitna · Apr 5th, 2002, 11:27 AM

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.

kluitna · Apr 5th, 2002, 11:50 AM

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

Al Chara · Apr 5th, 2002, 12:34 PM

Do you want something like the following:

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

kluitna · Apr 5th, 2002, 12:38 PM

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.

Al Chara · Apr 5th, 2002, 12:45 PM

Try the help files. They are a great resource. Use the microsoft online help too.

Apr 5th, 2002, 11:22 AM	#2
Al Chara MrExcel MVP Join Date: Feb 2002 Location: Monterrey, Mexico Posts: 1,433	Not sure if I understand your query, but are you looking for worksheets("Sheet1").Columns(1).select, which will select column 1 on Sheet1? __________________ Kind regards, Al Chara

Apr 5th, 2002, 12:34 PM	#5
Al Chara MrExcel MVP Join Date: Feb 2002 Location: Monterrey, Mexico Posts: 1,433	Do you want something like the following: Intersect(Range(Rows(6), Rows(75)), Columns(3)).Select __________________ Kind regards, Al Chara

Apr 5th, 2002, 12:45 PM	#7
Al Chara MrExcel MVP Join Date: Feb 2002 Location: Monterrey, Mexico Posts: 1,433	Try the help files. They are a great resource. Use the microsoft online help too. __________________ Kind regards, Al Chara

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 5th, 2002, 11:05 AM	#1
kluitna Board Regular Join Date: Mar 2002 Posts: 75	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

Apr 5th, 2002, 11:27 AM	#3
kluitna Board Regular Join Date: Mar 2002 Posts: 75	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.

Apr 5th, 2002, 11:50 AM	#4
kluitna Board Regular Join Date: Mar 2002 Posts: 75	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

Apr 5th, 2002, 12:38 PM	#6
kluitna Board Regular Join Date: Mar 2002 Posts: 75	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.