Yes, but only after you've captured the value of FinalRow with the assignment
FinalRow = Selection.Row following the xlDown. And be careful with the
quotes... In the original code, a line like "D5:D101" has quotes to indicate
a string. You'd replace that with "D5:" & FinalRow. You still need to get
the quote AFTER the string literal (D5:), or you'll wind up with compile
errors.

"JasonP CCTM LV" wrote:

The "101" referenced in the macro comes from the fact that the table I
created the macro with had 101 rows.

So all I need to do is replace that "101" with "& FinalRow" ?