Results 1 to 10 of 10

Changing target cell formatting

Threaded View

  1. 04-19-2016, 10:12 AM #6
    brunces
    brunces is offline
    Registered User
    Join Date
    03-25-2004
    Posts
    54

    Re: Changing target cell formatting

    Just out of curiosity, millz, could you please explain this to me?

    IIf(lngColor = 16777215, xlNone, lngColor)

    What does this function do? Mainly the numer 16777215. Why that specific number?

    Thanks again.

    brunces

    --- EDITED ---

    By the way, I'm having problems with logging in/posting/editing here. Is this forum facing any kind of problems? :/
    Last edited by brunces; 04-19-2016 at 10:16 AM.
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Changing row height of target cell
    By brunces in forum Excel General
    Replies: 2
    Last Post: 04-14-2016, 07:25 PM
  2. Solver is not changing values in target cell using through VBA
    By brajpalshishodia in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 04-19-2015, 02:52 PM
  3. Changing Formula based on what is in the target cell
    By 5upgraphics in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 02-02-2014, 05:54 PM
  4. system time stamp a cell when change in target cell. ( note target cell is formula ref)
    By R_VBA in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-22-2013, 11:38 AM
  5. Date format in cell Private Sub Worksheet_Change(ByVal Target As Excel.Range)
    By Hilton1982 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-15-2012, 03:22 AM
  6. Is target.offset my answer? Adapting code to format an adjacent cell.
    By thespianchef in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 01-19-2012, 04:18 PM
  7. format cell colour dependant on comparison to target value and 0
    By Kirsten2010 in forum Excel General
    Replies: 5
    Last Post: 04-29-2010, 07:11 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1