Excel Tab

[SimpleSimon62]

I'm sure its possible to populate the excel tab, from data within the same worksheet, but how do you do it?

 

[SimpleSimon62]

Pete

thanks for the help, but it does not work.... have i done something wrong ?

removed bad image

 

[SimpleSimon62]

tied pasting a copy but did not work,

 

[Joe4]

If you would like to paste an image, you can use the tools described here: http://www.mrexcel.com/forum/about-board/508133-attachments.html
I would recommend trying it out in the Test Here forum first, to make sure you have it working right before posting it to this thread.

 

[blbat]

Pete,

Nice bit of code...

is there an advantage to using .Formula as opposed to using .Value?

as in:

Private Sub Worksheet_Change(ByVal Target As Range)
    
    If Not Intersect(Target, Range("A1")) Is Nothing Then
        If Target.Cells.Count = 1 Then
            If Len(Target.Value) > 0 Then
                ActiveSheet.Name = Range("A1").Value
            End If
        End If
    End If

End Sub

 

[NewOrderFac33]

blbat - thanks for the comment - no, not that I'm aware - I suppose it depends on what the cell contains.

 

[NewOrderFac33]

Simon,

You were able to paste it in and it didn't work?

Where did you paste it?