+ 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
    Excel 2016, Excel 2019
    Posts
    691

    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
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider (Windows 11 64-bit)
    Posts
    52,480

    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!

    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.
    Don't forget to say "thank you" to those who have helped you in your thread. If you wish, you can also reward them by clicking on their reputation star bottom left.

  3. #3
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2016
    Posts
    7,017

    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
    Excel 2016, Excel 2019
    Posts
    691

    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
    Excel 2016, Excel 2019
    Posts
    691

    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 2016
    Posts
    7,017

    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. [SOLVED] 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