Need Help Setting Cell Values
 

Hi all,

I have what should be a fairly easy question that I need some help with.
I'm using Excel 2003.

I'm parsing a file and reading the needed data into a worksheet.

I've created a Module to do the file parsing and the parsing works great.
All I need to do is get the data into a worksheet. I can't seem to figure
out how to do that.

What I want to do is something like this:
Sheet("nameOfSheet").Row(i).Column(1).Value = amt1
Sheet("nameOfSheet").Row(i).Column(2).Value = amt2

The lines are in a loop and the row value is being incremented by 1. So
when it's all done, i have however many rows and 2 columns of data.

I keep getting the following error:
Object doesn't support this property or method

I'm at a complete loss. Adding ThisWorkbook. doesn't solve anything.

Any help is greatly appreciated.

Thanks,
Jay

Need Help Setting Cell Values
 

The syntax is a bit off - use this

Sheet("nameOfSheet").cells(i,2).Value = amt2

Good luck



--
www.alignment-systems.com


"Jay" wrote:

Hi all,

I have what should be a fairly easy question that I need some help with.
I'm using Excel 2003.

I'm parsing a file and reading the needed data into a worksheet.

I've created a Module to do the file parsing and the parsing works great.
All I need to do is get the data into a worksheet. I can't seem to figure
out how to do that.

What I want to do is something like this:
Sheet("nameOfSheet").Row(i).Column(1).Value = amt1
Sheet("nameOfSheet").Row(i).Column(2).Value = amt2

The lines are in a loop and the row value is being incremented by 1. So
when it's all done, i have however many rows and 2 columns of data.

I keep getting the following error:
Object doesn't support this property or method

I'm at a complete loss. Adding ThisWorkbook. doesn't solve anything.

Any help is greatly appreciated.

Thanks,
Jay