Making Simple Recorded Macro Generally Applicable

These are the first two steps in a multi-stage macro I've recorded to grab a block of data, remove problems such as merged cells and percentages, throw out data I don't want, and sort the remaining values in which I'm interested. It's useful, but since it reflects the conditions of its recording it only works with columns of 204 rows. (This is why 204 and numbers close to it occur a lot below). What would I have to do to make the 204 a variable that I would input at the beginning, so that I could manipulate columns of any size?

I won't bore the helpful people on this board with the full macro, but if someone could demonstrate how to generalize my first two steps, I'll be able to apply the principles to the rest. Thanks very much.

The code:

Please Login or Register  to view this content.

Thank you--that puts me on the right track.

Originally Posted by TMShucks

I'm a little confused about the ActiveCell part of your code though. Can the code be initiated from anywhere in the sheet?

No, the top left cell of the block of data to be manipulated has to be the active one at the beginning for the whole thing to work--if I've understood your question correctly.