View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Kevin Kevin is offline
external usenet poster
 
Posts: 504
Default 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