Hi Ray:

ActiveSheet

Regards,

Vasant.

"Ray Morton" wrote in message
...
I want one macro to create a chart over a set the same amount of cells no
matter what the worksheet or workbook is named. Is there some
"activeworksheet" command that I can use in my code that will work no matter
what the name is? So far the code is getting hung up on setting the source
data with a specific worksheet name. any suggestion would be greatly
appreiciated.