Problem with Rectangle

T

Tiago

In office 2003 i used a macro that play with rectangles, and everything fine

But now in Office 2007 give me a run time error (1004) Application-defined
or object-defined error.

the code is:

Workbooks(fich_curto).Sheets(nome_sheet).Shapes(rectang).TextFrame.Characters(Start:=lnInitialCharCount
+ k * 255 - 254, Length:=255).Text = Mid(Workbooks("OPEX
Comments").Sheets("Sheet2").Range("J17").Value, k * 255 - 254, 255)


Should i have to install any reference? ou any other stuff

Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Code OK in XL2003 but Run-time error '1004' in xl2007 0
Runtime Error 1004 1
Problem with ExportAsFixedFormat with selected sheets 0
VBA Workbooks.Open() / method 'open' of object 'workbooks' failed 0
dealing with different workbooks 1
Problem adding shape with VB .net 0
Copy range from one workbook to another 6
Problem with Hiding Every Other Column - Still need Help 3

Top