+ Reply to Thread
Results 1 to 6 of 6

Correct coding so as to highlight in colour the cells correctly selected

  1. #1
    Forum Contributor Potholes's Avatar
    Join Date
    11-25-2011
    Location
    Brisbane
    MS-Off Ver
    Office 2021
    Posts
    774

    Correct coding so as to highlight in colour the cells correctly selected

    Hi All

    In the thread as listed below I requested help to coreect the coding when I moved several groups of cells.

    https://www.excelforum.com/excel-pro...ml#post5343510

    I have managed to set the correct cells location in some of the coding, however when I select a word it
    moves it and reset counters and such, BUT does not highlight the cells to show that it has been acted on.

    See cells R3 down and accross, I trust you can make sense of what I am asking for.

    See attached file named " Finder Vr2.06_PBH.xlsm"

    Note I have marked the https://www.excelforum.com/excel-pro...ml#post5343510

    Regards and

    Thank you

    Peter

    Posted Ozgrid

    https://www.ozgrid.com/forum/index.p...ctly-selected/
    Attached Files Attached Files
    Last edited by Potholes; 06-04-2020 at 11:23 PM.
    One I have learnt over the last few months, " You are NEVER too old to learn ".
    Sometimes I forget to say " Thank You " for your assistance, so here I say " A BIG Thank You. "

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,397

    Re: Correct coding so as to highlight in colour the cells correctly selected

    There was no need to open a new thread, and by doing so you have introduced the potential for confusion, so I have closed the older thread with a link to this one.
    Last edited by AliGW; 06-05-2020 at 12:54 AM.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  3. #3
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,904

    Re: Correct coding so as to highlight in colour the cells correctly selected

    Yep, Confused me too.
    Will pick this one up
    ---
    Hans
    "IT" Always crosses your path!
    May the (vba) code be with you... if it isn't; start debugging!
    If you like my answer, Click the * below to say thank-you

  4. #4
    Forum Contributor Potholes's Avatar
    Join Date
    11-25-2011
    Location
    Brisbane
    MS-Off Ver
    Office 2021
    Posts
    774

    Re: Correct coding so as to highlight in colour the cells correctly selected

    Hello Ali & Hans
    I presumed that the basics of the code had been fixed, That I should cast out a new line so to speak
    just to over a new topic.

    I apolalgise if i have erred .

    Still in a bit of pain after the 2 ops, and cannot see a 100% yet.

    Pete
    Last edited by Potholes; 06-05-2020 at 02:45 AM.

  5. #5
    Forum Contributor Potholes's Avatar
    Join Date
    11-25-2011
    Location
    Brisbane
    MS-Off Ver
    Office 2021
    Posts
    774

    Re: Correct coding so as to highlight in colour the cells correctly selected

    Hi all

    Problem solved

    Many Thanks to all


    Peter

  6. #6
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,904

    Re: Correct coding so as to highlight in colour the cells correctly selected

    If it's solved, don't forget to mark the post as SOLVED

+ 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. Colour coding cells
    By Allan muturu in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 11-01-2019, 01:26 PM
  2. Colour coding date cells when one month due
    By Lisa-Marie in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-16-2019, 05:26 AM
  3. Colour coding matching cells.
    By southside in forum Excel General
    Replies: 3
    Last Post: 01-10-2016, 12:23 PM
  4. Colour Coding Cells If Contracted Hours Not Met
    By suma in forum Excel General
    Replies: 3
    Last Post: 01-03-2012, 07:40 PM
  5. colour coding cells
    By gazza uk in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 09-08-2010, 06:33 AM
  6. Colour coding cells
    By shimoo_c in forum Excel General
    Replies: 2
    Last Post: 03-27-2009, 05:51 AM
  7. change highlight colour of selected cells
    By Starskys Bird in forum Excel General
    Replies: 1
    Last Post: 04-29-2006, 09:30 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1