Run Time Error: Reference Not Valid

[SBNUT]

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

 

[johnnyL]

The part you have highlighted in yellow you can try replacing with:
R" & lastrow & "C10"

 

[sax2play]

try this:

"Job List!R7C1:R" & lastrow & "C10"

 

[SBNUT]

Thanks, that worked like a charm.

 

[sax2play]

Thanks, that worked like a charm.

Thanks for the feedback. Will you mark the solution so others know what resolved your error?

 

[johnnyL]

You are welcome @SBNUT. Glad we could help.