current worksheet

K

Kevin

Hi

How do i use VB code to find name of current worksheet. I run same macro
from different sheets to copy data to another. I want the code to figure out
the current worksheet and make reference to this sheet in a paste area

thansk
 
Top