Hi Edmund,

What you're doing is not proper syntax. For example, if the active sheet's
name is "Sheet1" then using the string variable like you are means you're
actually doing this:

Call "Sheet1"

when what you want is:

Call Sheet1

You need to implement a select case structure so you can redirect based on
the sheetname. ..Just one way to go!

HTH
Regards,
GS