hi i got a sheet which I copy and insert it at the end of the workboo
problem is that I have a rectangle which I would like text to be insid
however it changes names as soon as I copy it is there a way I could us
like a variable to do what I want with the only shape on my sheet.
Code
-------------------
Sub Macro6()
ActiveSheet.Shapes("Rectangle 1627").Select
Selection.Characters.Text = "hello world. Its" & Now()
End Sub
-------------------
--
funkymonkU
-----------------------------------------------------------------------
funkymonkUK's Profile:
http://www.excelforum.com/member.php...fo&userid=1813
View this thread:
http://www.excelforum.com/showthread.php?threadid=54469