Receiving an error message for VBA

mjp11 Posts 1 Registration date Thursday March 3, 2016 Status Member Last seen March 3, 2016 - Mar 3, 2016 at 12:54 PM
 Blocked Profile - Mar 3, 2016 at 07:28 PM

I was given a workbook to fix with 5 different sheets. The Summary sheet has a button to "Refresh Equipment List" which is supposed to pull data from 5 different columns on the Equipment sheet and build a new chart on the Summary sheet. There is already a VBA in place but when the button is pressed this comes up:

When I open the debugger the module opens up like this:

How do I make the button functional? Any help is appreciated as I am not familiar with VBA.
Thank you!

1 reply

Blocked Profile
Mar 3, 2016 at 07:28 PM
It looks as though you are referencing an already named "RANGE". Place that variable name into the range on the line before that one. The variable either has to be set static in the sheet, or programatically. The later of the two would be define it in the line before the one that fails.