Call Function in VBA

[Eurekaonide]

Hi All

How do I use the Call function in VBA to call up another piece of code automatically which is a Sub?

 

[Andrew Poulsom]

Like this:

Call YourMacro

replacing YourMacro with the name of the procedure that you want to run.

 

[Ruddles]

I answered this half an hour ago: http://www.mrexcel.com/forum/showthread.php?t=550943 (posts 10 & 11).

 

[Eurekaonide]

Thank you All - Apologies I didn't realise the previous request had fallen onto two pages

Thanks will give it a go.