Aziz saathion aik excel ka masla hay,
mujhay yeh poochna tha ke excel mein ham agar aik entry maslan sr. no. 5 par clik krain to us ke sath wali entry automatically color fill hogaye.
Aziz saathion aik excel ka masla hay,
mujhay yeh poochna tha ke excel mein ham agar aik entry maslan sr. no. 5 par clik krain to us ke sath wali entry automatically color fill hogaye.
(neechay diyay gaya code alt+f11 kar k us sheet mein paste kardo jis sheet par highlight karna hai to aapka kaam ho jayay gay InshaAllah)
Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
'Update 20140318
Static xRow
Static xColumn
If xColumn <> "" Then
With Columns(xColumn).Interior
.ColorIndex = xlNone
End With
With Rows(xRow).Interior
.ColorIndex = xlNone
End With
End If
pRow = Selection.Row
pColumn = Selection.Column
xRow = pRow
xColumn = pColumn
With Columns(pColumn).Interior
.ColorIndex = 6
.Pattern = xlSolid
End With
With Rows(pRow).Interior
.ColorIndex = 6
.Pattern = xlSolid
End With
End Sub
bohat bohat shukria sir,
mein check karta hoo,
lekin vb script ke ilawa koi aur tareeqa hoo to wo bhe share kardein
Bohat shukria bhai,
Yeh code bilkul shi kam kar rha hay lekin agar koi or tareeqa bhi ho to wo bhi share kar dein
Bohat bohat shukria is thread to closed kardia jia.
Bookmarks