Application.Run Range ("WORKSPACE.REFRESH") -what is this?

[alane]

Hello - I am very new to VBA and taken over a macro file written by someone else, and I am trying to make some adjustments and understand the code.

this line
Application.Run Range ("WORKSPACE.REFRESH") appears a number of times (the macro is going between 2 files). There is no Range in the file with this name.

can anyone let me know why this is here and what it does - I have tried recording a couple of very easy macros, to copy , paste into a new file and save - which work fine - and I don't see this line appearing at all. is it really needed?

many thanks
alane

[:) Sixthsense :)]

Check the Named Range "WORKSPACE.REFRESH" by pressing Ctrl+F3, in which the macro names are entered and called using that code.

[JosephP]

you might try running this

Please Login or Register  to view this content.

[alane]

When I hover my cursor over the Range it shows:
Range ("WORKSPACE.REFRESH") = < Method 'Range' of object '_Global' Failed>

I think the person who originally wrote the macro was quite technical, so is it maybe in there to give me an error if there is one, but I've never seen that error message coming up when macro is run so maybe i can ignore that line?

[JosephP]

where exactly is the original run code located and which workbook is active when it runs? (you need to make sure that the same workbook is active when testing the range)

[JosephP]

perhaps try

Please Login or Register  to view this content.

[alane]

Thank you very much, I will try you suggestions when I am back at my work computer tomorrow. Such a lot to learn for VBA! No-one else at work has the know-how so I am trying to self teach. Thanks :-)