I've recorded a macro that has everything sorted reverse alphabetically (by
column H). My data goes from A3:Jxx where xx is the last cell in my worksheet
(LIST won't work for me-column F is mostly empty). I need to remove
everything in the T range (all cells' text in column H begins with T), then
move everything in the R range (all cells' text in column H begin with R) up
to A3.

How do I find the last cell in column H that goes with each of these ranges?
Or maybe the beginning & end of each range?

I also have an N & C range also, but I need a start to figure out how to
deal with them.