Pass value to sub in .xla

[mdmackillop]

Can I pass a value to a sub routine in a .xla file?
I've tried

Application.Run "Valbook.xla!PageStart 40"
with no success.

[JKwan]

I think you should be able to pass values to an XLA. I referenced my xla then call it by MyFunction.Procedure (xxx)

That worked for me

for you may be Valbook.PageStart (40)?

[mvidas]

Malcolm,
Have you tried

Application.Run "Valbook.xla!PageStart", 40
Seems like one of those silly syntax moments :doh:
Matt

[mdmackillop]

Thanks Matt and JKwan. I missed the comma!:banghead: