How to determine range to select once a reference cell is found?

So i am a complete newb to this and am looking for help on something that should be simple. This is my first real attempt at writing anything in VBA. I am pulling data from a txt file and then parcing the data to find what I need. I got the code figured out to find a reference cell and select it. The cell selected is the last of 80 cell group I want to copy and copy it to a new page. I also know the text in the line 80 cells away (Az,Ze,Ds,Tolerence,Error). Because that line is generic and used multiple times in 15,000 lines of data I'm not sure if that would be an issue. Here is what I have:

Please Login or Register  to view this content.

Moderators Note: Please follow Forum Rule #3 and use code tags. Added this time, but please use them in the future…Thanks.

Not sure what you're trying to achieve, but let's assume that the cell you select is the topleft cell of the range your trying to determine.
Then you could use a syntax like:

Please Login or Register  to view this content.

where x,y represents the bottomright cell of the range you need. X being the number of rows between the active cell's row and the bottom row and Y being the number of columns between the active cell's column and the right most column of the desired range.
Of course you can alter x and y to meet you're needs if different.