Help Debugging

[kellynicolebarrett]

Hi,

Can anyone please help with the below, I have no idea when it comes to debugging!

When I click a refresh button on my worksheet, it ends up showing a debug eroor message. I don't really understand what the issue is, why it won't work.

I've attached a pic and the spreadsheet. If anyone can explain what's goin on or help fix it that would be AMAZING!!!

Kelly

DEBUG.jpg

[adyteo]

I believe that in sheet Shift, range C23 is outside the table.
Can you change the code from:

Please Login or Register  to view this content.

to:

Please Login or Register  to view this content.