Object Required
Hi Patrick,
When Excel names a Text Box it includes spaces so you might still have
trouble if those spaces are not included. Also, on my machine the .Text
doesn't work, I've had to use .TextFrame.Characters.Text, so maybe it
should be..
ActiveSheet.Shapes("Text Box 88").TextFrame.Characters.Text = etc
Ken Johnson
|