Hi guys,
I'm having a little difficulty in tweaking some vba that I have got from a recorded macro. When I run it, I get the message 'Run-time error 1004, Method Range of Object_Global failed'.
Once I click Debug, the VBA sheet opens. When I close it the macro has done what I wanted it to do...