View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Boo Boo is offline
external usenet poster
 
Posts: 21
Default copy name from active sheet to cell - using macro or function

Code you need is:

Cells(1, 1).Value = ActiveSheet.Name

Assign the macro to a shortcut key, object or event (depending on your
preference).

"dymek" wrote:

Hello,

I'm newbie I'm looking for function or macro which can give copy name of
worksheet to cell in eg. A1.

Is it possible?

Of course function is the best option.

Thanks in advance.

Rgs,
dymek