I have a table with the Period horizontally across the first row and then 8
lines of Budget items below the Period.
I can do an hLookup and it returns the correct column but it is showing the
data, (Budget) not the R1C1.
i.e varGroupStart = Application.WorksheetFunction.HLookup(i,
Range("Project_BudgetAllocation_FullRange"), 2, False)
When I look at varGroupStart it shows "279,186".

How do I get it to tell me it is H20?

I need this because then I do an offset :

varGroupStart.Select
varGroupEnd = ActiveCell.Offset(8, i)

in order to select and copy the values.

Thanks for your advice.

Rick