Displaying The Active Sheet Name In A Cell ...

When a change is made in one page, this will update:
Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
Worksheets("Sheet1").Cells(2, 12) = ActiveSheet.Name
End Sub
This macro has to be placed in ThisWorkbook.

Hi,

If you need a formula to read your worksheet tab ...

Please Login or Register  to view this content.

Hello Carim and Ray, Need to ask a few questions:

I didn't mention but I need this Cell to update each time I create a new
sheet (Receipt) to represent the tab name which I am labeling 00001 and so on.
I am trying to create a way to automatically increase the Receipt Number
each time I create a new Receipt (Sheet). The Receipts Numbers to be
updated are in cell L3.

This is why I believe a cell formula will work better than an actual Macro.

Carim The formula you presented only return the text formula itself. I am
assuming where you have 'filename' you mean the path of the workbook?
I am lost here, please help.. The workbook Name Is 'Universal Receipt' the
opening sheet is '00001'... Thanks for any help on this..

Ray if i use a macro, would it be able to update this cell each time a new
sheet (receipt) is created? thanks for any info here...

Hi,

Save your workbook once ... for the formula to be effective ...

You are welcome ...

Very glad to see it is a big relief for you to have fixed your problem ...

Thanks a lot for your kind feedback ...