Excel97VBA- recognize last cell in column when not known 1

[MrsTFB]

Hey guys,
I am importing data into Excel97 from a Data Acquisition program. What I want to do is write code that when executed, it will delete the first and last row of data, then perform some calculations in another area.

I can write most of the code, but I'm not sure how to define my range as it will vary based upon the number of entries from the DAQ. They will always be in the same columns, A,B, and C, but the row number will vary.

Any ideas?

Thanks for your help.
Bsimm GO TITANS!

 

[logius]

Try this site:

http://www.microsoftexceltraining.com/ExcelRanges.html

It has a lot of info on working with ranges. You can probably figure something out from there.

 

[MrsTFB]

Perfect!! Thanks! Added to my favorites and gave you a vote.

I LOVE THIS SITE!! :-X

Bsimm