+ Reply to Thread
Results 1 to 5 of 5

Help with VBA for highlighting active row

Hybrid View

  1. #1
    Forum Contributor Marvo's Avatar
    Join Date
    01-15-2009
    Location
    Northampton, England
    MS-Off Ver
    Excel 2021
    Posts
    990

    Help with VBA for highlighting active row

    Hi, I've been trying to follow this video on utube on how to highlight a row

    https://www.youtube.com/watch?v=yJiygLKrwBc

    I get as far as right clicking on the sheet to view code but when I get there it's blank. If I copy the woring the instructor uses, it shows it in red and says something like "expected ending".

    Can anybody tell me where I'm going wrong please.

    I've attached the workbook, it's on worksheet "Master"

    Many thanks.

    Edit: Does it have to be a table?
    Attached Files Attached Files
    Last edited by Marvo; 02-29-2024 at 01:34 PM.

  2. #2
    Forum Contributor Marvo's Avatar
    Join Date
    01-15-2009
    Location
    Northampton, England
    MS-Off Ver
    Excel 2021
    Posts
    990

    Re: Help with VBA for highlighting active row

    It's okay, I've done it!

  3. #3
    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. 2407 (Windows 11 23H2 64-bit)
    Posts
    82,883

    Re: Help with VBA for highlighting active row

    Please share the solution.
    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.

  4. #4
    Forum Contributor Marvo's Avatar
    Join Date
    01-15-2009
    Location
    Northampton, England
    MS-Off Ver
    Excel 2021
    Posts
    990

    Re: Help with VBA for highlighting active row

    Well, I went to another video and followed the steps in there. In the first video it said to right click on the worksheet and select view code. In the second video it said to click on Visual basics under the developer tab. This time when I did that I got the words up in which to surround the VBA code the first video gave me and it worked. That's all I can tell you.

  5. #5
    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. 2407 (Windows 11 23H2 64-bit)
    Posts
    82,883

    Re: Help with VBA for highlighting active row

    Thanks. It may help someone else.

+ 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] highlighting the active row/column
    By Chris220 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-09-2019, 11:19 AM
  2. Highlighting the active cells or table?
    By oneblondebrow in forum Excel General
    Replies: 1
    Last Post: 10-22-2016, 04:44 AM
  3. Replies: 22
    Last Post: 01-26-2016, 07:43 AM
  4. Highlighting Active Cell in a Table
    By Statto in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-04-2014, 08:51 AM
  5. Highlighting Active Cell
    By TheSeal in forum Excel General
    Replies: 2
    Last Post: 07-20-2007, 04:06 AM
  6. Highlighting an active cell
    By pjy in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-02-2006, 12:40 PM
  7. Highlighting The Active Cell
    By Pelham in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-01-2006, 10:00 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