I am trying to dynamically select a row number. I have code that works that has the static row (commented out below), however when I change the code to dynamically get the last row number for the select statement, I get the Run Time error. The code to return the last row number works because when uncommented the Message box, it returns row 17. But when I change the code to get the dynamically selected row number (Highlighted in yellow) the error occurs. Does anyone see what I have done wrong? Thanks