Vlookup in VBA - Live Weekend Workshop

Grab the Free VBA Quick Reference Guide
https://www.chrisjterrell.com/excel-vba-quick-reference-guide/
Hi All, I keep getting requests for help so I thought I would start doing some weekend workshops.

These will be an open forum for questions and challenges. We can go over VBA, Excel, Google Sheets. SQL, or anthing else that comes up

Sub Vlookup()

Dim rng As Range

Columns("E:Z").Columns("E:Z").ClearFormats

Set rng = Range(Range("b6").Value)
rng.Interior.Color = Range("c6").Interior.Color
For Each cl In rng
If cl.Column = rng.Cells(1, 1).Column Then
cl.Interior.Color = Range("C5").Interior.Color

If cl.Value = Range("B5") Then

cl.Resize(1, Range("b7")).Interior.Color = Range("C7").Interior.Color
Range("b10") = cl.Offset(0, Range("b7") - 1)

Stop

End If

End If

Next

End Sub

Видео Vlookup in VBA - Live Weekend Workshop канала EverydayVBA