I am creating a Macro which sorts and adds a formula to the right of a
column. I want to be able to fill down the data, without creating a range
because the number of rows can change. I want the formula to fill down to
the last active cell in the column on the left of the formula. Is there a
shortcut key I can use when recording the macro?

Thanks.
Cathy U