cell features to appear in formula

[RIZVI]

hello friends,

attached is a SAMPLE document where you will see that A7 represents a formula representing cells A1:A4.
A1:A4 cells have different features such as some are bold, underlined, different in size etc.
how can i get cell A7 to appear having same features of cells A1:A4?
could we have a general VBA so that first it checks for bold, underlined text as per contents in the formula and thereafter it shows the exact contents as appearing in the selected cells.

thank you

regards
rizvi

[sourabhg98]

Hi
Not possible without VBA.
Try this macro-
This would loop through the specified number of rows starting from A1 and would copy color, size, bold, italics, underline property.

Please Login or Register  to view this content.

[RIZVI]

hi sourab,

tried, but not working.....

regards