error with textbox properties

mdavide

Board Regular
Joined
Oct 19, 2004
Messages
211
HI all,

I have a macro that builds a report with many charts (same type, same format, different value) , inside every chart area I have a textbox (named txt as shape)
after setting about one hundred charts correctly, this line below gives me an error (#1004, say the property cannot be changed)

txt.TextFrame.Characters.Font.Bold = True

why?

DM
 

Some videos you may like

Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)

mdavide

Board Regular
Joined
Oct 19, 2004
Messages
211
this error seems to be general, about the workbook. it seems that I reach an unknown-to-me limit (number of character type, I suppose).

anyone have a clue about it? I don't know what produces it and how to treat it.

DM
 

Watch MrExcel Video

Forum statistics

Threads
1,119,144
Messages
5,576,326
Members
412,716
Latest member
thviid
Top