Hey p45cal,

Hope you're well.

I'm still on this project (literally finishing now) but got stuck with one thing.
I need to add slicer which will filter pivot charts by specific business weeks.

I've got table in 'Lists' tab with dates and wk numbers (L:N).

In last column (13) of my Tracker I want output of vlookup which will basically take today's date, find it in column L and then return WK number from column N.

I've done below sub:

Sub vlookup1()


Dim Tracker As Worksheet, Lists As Worksheet
Dim dataRng As Range
Dim stamp As Long
Dim wk As Long

Set Tracker = ThisWorkbook.Worksheets("Tracker")
Set Lists = ThisWorkbook.Worksheets("Lists")
Set dataRng = Lists.Range("L2:N380")
Set stamp = [Text(Now(), "DD-MM-YYYY")]

wk = Application.WorksheetFunction.VLookup(stamp, dataRng, 3, False)



End Sub
Does this one look legit?
If so, how do I call output of this formula to appear in column 13?

.Cells(iRow, 13) = ????

Tried multiple ways (everything I could think of really), but can't make it work :/