Sort And Subtotal Part Data

I have data with two types of records: those with "orders" in teh comments field and those with something else in that field. I'm able to sort on comments so "orders" records appear at the bottom, and insert two blank rows, separating the two datasets. Now I have to be able to set the range of the top portion. I worked on the problem, and used some of the code in the response to my post. I need to store two cell addresses.

To determine the range, I find the first blank column, then move one cell to the left, then I need to store that column's letter. AFter I find the first row with "orders" in the comments, I need to insert two blank rows and move back up to the row above that containing data (this much I've done), then store that cell's row's address. I need to use the column and row I record as the range to select for the sort. So, I basically need to things:

1. How to store the active cell's column and row
2. How to stop recording, type in code, then resume recording.