+ Reply to Thread
Results 1 to 2 of 2

Hard Question: An intelligent vba macro which read cell styles and combine with styles ?

  1. #1
    Forum Contributor
    Join Date
    07-17-2012
    Location
    N/A
    MS-Off Ver
    Excel 2010
    Posts
    218

    Question Hard Question: An intelligent vba macro which read cell styles and combine with styles ?

    You know, default CONCATENATE function removes the styles of cells. I need more complicated like that:

    A B C D E
    1 Bold Italic Normal Red =AdvancedConcat(A1:D1)
    Bold
    Italic Normal Red


    Is it possible?

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Hard Question: An intelligent vba macro which read cell styles and combine with styles

    Short answer, no.

    You can't apply a mix of formats to the result of a fomula, you can only do it with a value.
    If posting code please use code tags, see here.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1