application.run Query

[patcunn]

Hello,

Could some please help with this.

currently I have a macro ( "clear") ( it just clears a worksheet) which I can run remotely from another workbook ( Russia2007.xls").

The macro runs fine from any workbook and any worksheet

Application.Run "Russia2007.xls!clear"


What I wanted to do was get the macro to run on a different worksheet than the active worksheet.

eg ..if my current worksheet is "sales" and I want to run Application.Run "Russia2007.xls!clear" to clearworksheet "depts"

it doesn't seem to work.

I thought this would work..Sheets("depts").Application.Run "Russia2007.xls!clear"


I currently get around this by

this_sheet = ActiveSheet.Name
this_cell = ActiveCell.Address
sheet("depts").select
Application.Run "Russia2007.xls!clear"
Sheets(this_sheet).Select
range(this_cell).Select

I just wanted to streamline the process without having to jump to the sheet and run the clear macro.

Any help would be greatly appreciated.

Regards,

patcunn.

[Olly]

Post the "clear" code.

Oh, and please use CODE tags when you post code.