from post 6:
That and stepping through are the 2 most important things you can do to spot a problem.
Have to think that you still are not doing that or you would have reported what the value of LastRow is. As was pointed out, anything in any cell in a row will be regarded as being a used row. Don't fudge things, fix things. Not sure how you can arbitrarily (?) decide which rows are empty (but apparently are not) and delete. Perhaps your Cloud sheet has a wayward entry.
unsure why but 3 quotes works!
That is a researchable question, yes? But here you go (hope you don't mind the emphasis):
1st denotes the start of a string


2nd of a pair denotes the end of a string
3rd tells Access it is the end of a string and what lies between 1st and 3rd is literal text

Not that I have this down pat because I would have thought you'd need a 4th at the end; the first three as described and a 4th to act as the "mate" to the very first one. Have seen that in many places. Humor us and add one to the very end and see if Access removes it, complains, or if it still runs?