Insert A Word Object In Excel, Type, Then Resize

insert a word object, type... and resize...

Dim objX As OLEObject
Set objX = ActiveSheet.OLEObjects.Add(ClassType:="Word.Document.8", Link:=False, DisplayAsIcon:=False)
    objX.Border.Color = RGB(255, 255, 255)
objX.Height = 200
objX.Width = 600
objX.Top = 300
objX.Left = 100
'-------make active
objX.Activate
    Set objX = Nothing

i would like to place the object in a worksheet and have all the rows of data move down below the word object (i.e., below the word object--i do this resizing manually now...)...?

???

thank you...!

Re: Insert A Word Object In Excel, Type... And Resize...

well, maybe...

i'm inserting the word object in a worksheet...

???

thanks.

Re: Insert A Word Object In Excel, Type, Then Resize

well, i like using the features of word (is the only reason)...

but i'm open to suggestions...?how would i push the text box to one row below the last row...?

thanks.