VBA - runtime error 94, invalid use of null

dude you need to make a selection in c column for it to work

Of course, but regardless of that, the error still occurred. Cheers for your response anyway!