ReePrime
Blog DMC
MIS Excel Tricks - 5

Hosted by Dailymotion. For legal issues report at the Copyright Center, report us on DMC, or use the Instant Removal tool.

MIS Excel Tricks - 5

R
RAKESH KUMAR

13 Views • Mar 03, 2023

Description

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Cells.Interior.Color = vbWhite

Dim ROW_NUMBER As Integer
Dim COLUMN_NUMBER As Integer

ROW_NUMBER = ActiveCell.Row
COLUMN_NUMBER = ActiveCell.Column

For I = 1 To COLUMN_NUMBER

Cells(ROW_NUMBER, I).Interior.Color = vbBlue
Next I

For J = 1 To ROW_NUMBER

Cells(J, COLUMN_NUMBER).Interior.Color = vbBlue
Next J
End Sub

Keywords & Tags

#ADVANCE EXCEL FORMULA #Excel Formula #Excel Function #Excel macro #EXCEL VBA #MAKE FOLDER WITH EXCEL VBA #MKDIR FUNCTION IN EXCEL VBA #MKDIR Function का उपयोग #text function #use of excel function #एक्सेल सीखें #Excel Test #Excel Question #Excel If Question #VBA MACRO #Advanced Excel Training #http:www.learn-excel-vba-macro.com #VBA CODING #VBA FUNCTION #MACRO CODING #index function in excel #Indirect function in excel #Address Function in Excel #Offsent Function in Excel #Excel tips #MIS INTERVIEW QUESTIONS #Excel Class #Excel training #Logical Formula #Logical Formula in excel #Conditional formatting #MIS INTERVIEW #Excel for data science #Excel for data analyst

More from User

01:00:12

39 Live SQL Practice Session 22 Feb 2026

RAKESH KUMAR

01:38:20

37 Live SQL Practice Session 1 Feb 2026

RAKESH KUMAR

01:28:24

36 Live SQL Practice Session 25 Jan 2026

RAKESH KUMAR

01:17:08

38 Live SQL Practice Session 15 Feb 20263

RAKESH KUMAR

57:49

35 Live SQL Practice Session 18 Jan 2026

RAKESH KUMAR

01:13:42

34 Live SQL Practice Session 11 Jan 2026

RAKESH KUMAR

Related Videos

08:37

Excel (Macro) VBA Part-2 | VBA - Cell Referencing | Debug Function - Step into | VBA Coding in Hindi

Tech Guru Plus(Nazim Khan)

04:38

MIS Excel VBA Macro Tips-2

RAKESH KUMAR

08:21

Excel Magic Trick 572: COUNTIF & SUMIFS functions & Logical Formulas have Different Syntax

Shalanda Farrow

17:17

How to Pass Excel Test for Job Interview_ Excel Formulas & Functions Questions and Answers

Family Entertainment

05:48

Excel (Macro) VBA Part-3 | Copy Data to another Sheet in Excel by Macro | VBA Coding in Hindi

Tech Guru Plus(Nazim Khan)

00:40

Holy Macro! It's 2,500 Excel VBA Examples: Every Snippet of Excel VBA Code You'll Ever Need | Read Books Online

Patriciabperron