current worksheet  
Author Message
GerriBaker





PostPosted: Wed Feb 27 03:36:01 CST 2008 Top

Excel Misc >> current worksheet

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
--
Kevin

Excel122  
 
 
MikeH





PostPosted: Wed Feb 27 03:36:01 CST 2008 Top

Excel Misc >> current worksheet Try this

myname = ActiveSheet.Name

Mike



> 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
> --
> Kevin