+ Reply to Thread
Results 1 to 3 of 3

Array Formatting

Hybrid View

  1. #1
    Forum Contributor
    Join Date
    05-13-2010
    Location
    Dallas, TX
    MS-Off Ver
    2019
    Posts
    133

    Array Formatting

    I'm putting string data in an array since arrays are much faster. Then I place the whole array into a worksheet. My question is, as I'm placing data into an array is there any way to also tag its formatting, like italics or bold? If there is, is there any way to change a certain part of an array string where part of it is normal formatting and the remaining is in italics, like "Jane Doe (nee Jane Smith)" where Jane Doe is not italicized and (nee Jane Smith) is italicized? On that last part, can that kind of formatting be done is a non-array, just a normal cell? Thanks.

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

    Re: Array Formatting

    I'm sorry but the answer is no, all you are putting in the array is the value.
    If posting code please use code tags, see here.

  3. #3
    Forum Contributor
    Join Date
    05-13-2010
    Location
    Dallas, TX
    MS-Off Ver
    2019
    Posts
    133

    Re: Array Formatting

    OK. How do you format a portion of a string in a worksheet cell?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Conditional Formatting on 2-D array
    By puneet1011 in forum Excel General
    Replies: 4
    Last Post: 04-02-2016, 05:03 AM
  2. [SOLVED] Array set for Conditional Formatting
    By Faridwahidi in forum Excel Formulas & Functions
    Replies: 19
    Last Post: 03-30-2016, 03:01 PM
  3. Using an array and conditional formatting
    By seangun in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 04-18-2014, 07:57 AM
  4. [SOLVED] Conditional formatting with IF/AND/OR (array's?)
    By anghicole in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-06-2013, 04:17 AM
  5. formatting cells within an array
    By mmarstaller in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-06-2010, 12:49 PM
  6. Array formatting
    By beaker56 in forum Excel General
    Replies: 5
    Last Post: 03-11-2009, 08:20 PM
  7. Formatting an array
    By mickiedevries in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-11-2006, 02:45 PM

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