Cell Reading Questions

[cionnaith]

Good Day Everyone!!

I have a couple of questions regarding reading from cells:

First, is it possible to read from a cell within a worksheet to name that worksheet tab? If so, how is that done in 2007?

Second, is it possible to read from a cell within a worksheet to name a figure (chart) within that worksheet? Again, if so, how is that done?

Thanks in advance.

c

 

[wigi]

To get you started:

this code will rename the active worksheet in the file, to the contents of cell A1 in that active sheet:

Sub f()

    Activesheet.Name = Range("A1").Value

End Sub

 

[cionnaith]

To get you started:

this code will rename the active worksheet in the file, to the contents of cell A1 in that active sheet:

Sub f()
 
    Activesheet.Name = Range("A1").Value
 
End Sub

Awesome. Thanks. Stupid question, though. Where is that code inserted?

 

[wigi]

In a normal module in VBA. You can choose Insert > Module in the menu of VBA. Paste the code and execute it once.