Receiving an error message for VBA

[Closed]
Report
Posts
1
Registration date
Thursday March 3, 2016
Status
Member
Last seen
March 3, 2016
-
 Blocked Profile -
Hello,

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


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.