R
rick
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
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