Highlight Current Row and Column in Excel with this VBA Code | Vivekananda Sinha | Video 185
Highlight Current Row and Column in Excel with this VBA Code | 21 Days Challenge | Day 09
This is the Nineth Day (Day 09) of my 21 Days Challenge. Combining Excel features with VBA is a magical combination. While looking at a big table of data, it would make our life much simpler if the active cell’s column and row are highlighted, so that we can visualize and get a sense of things. Unfortunately, Excel don't have any default featured for this. Here I am going to show a a simple VBA code that is perfectly working on our requirement. Here I have show you the combination of Excel's Conditional Formatting with VBA's Selection Change Event. It will work across all versions of Excel. Be it Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2019, Excel 365.
00:00 Start
01:08 VBA Program to store current Row & Column number
04:22 Adding Conditional Formatting
05:33 Wrap-Up
★ My Excel Bundle Course ► https://futureinhands.com/microsoft-e...
⯆ Download the file here: https://futureinhands.com/youtube/ass...
In this Excel tutorial we cover a few important topics rather quickly:
How to use Selection Change Event in VBA
How to Store Current Row Number and Column Number
How to Use Conditional Formatting in Excel
How to Highlight Row and Column of selected cell
★ MUSIC IN THIS VIDEO
Music by / ikson
★ Let’s connect on social:
Our Telegram Group: fih.one/club
My LinkedIn Profile: fih.one/vs-linkedin
My Facebook Profile: fih.one/vs-facebook
Our LinkedIn Page: fih.one/linkedin
Our Facebook Page: fih.one/facebook
#FutureInHands #VivekanandaSinha #MicrosoftExcel #MicrosoftOffice #ExcelVBA #21DaysChallenge