Tom Ogilvy wrote:
intMonthlyInitiativeHours = Application.Index(Range("A1:D4"), _
Application.Match("Smith", Range("A1:A4"), 0), _
Application.Match("Feb", Range("A1:D4"), 0))

Small typo: "A1:D4" should be "A1:D1".

If names are created out of the row and column headers,

intMonthlyInitiativeHours = [Smith Feb]

Alan Beban