+ Reply to Thread
Results 1 to 4 of 4

With Selection.interior

  1. #1
    Registered User
    Join Date
    12-12-2022
    Location
    Srilanka
    MS-Off Ver
    10,365
    Posts
    1

    Unhappy With Selection.interior

    ,, why " i " of "interior" is not capitalized

  2. #2
    Forum Guru HansDouwe's Avatar
    Join Date
    06-21-2022
    Location
    Nederland
    MS-Off Ver
    365 V2403 (Build 17330.20000)
    Posts
    6,435

    Re: With Selection.interior

    deleted ... (misread)

  3. #3
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,466

    Re: With Selection.interior

    Could you post the whole code and capture code window where "selection.interior" did not capitalized?
    Quang PT

  4. #4
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,436

    Re: With Selection.interior

    Selection is an Object and therefore it does not know exactly which property and methods are available.

    In order for intellisense to work the variable type needs to have been defined.
    Cheers
    Andy
    www.andypope.info

+ 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. Replies: 0
    Last Post: 01-11-2021, 03:57 PM
  2. Selection.Interior.PatternColorIndex
    By Marianus in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 03-05-2014, 04:38 AM
  3. [SOLVED] Trouble with Selection.Interior and .PatternColorIndex
    By tygrrboi in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 03-09-2013, 09:35 PM
  4. [SOLVED] Interior Colour Selection Query
    By timbo1957 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-18-2011, 05:01 AM
  5. Deleting cell interior of a selection + interior of the row above selection
    By Tim0l in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-24-2011, 07:32 PM
  6. [SOLVED] Selection.Interior.ColorIndex
    By mpeplow in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-08-2007, 07:28 PM
  7. selection.interior
    By Eric Shamlin in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-02-2005, 06: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