Row & Column headings to refer to cells in VBA6

Hi everyone,
suppose we have data in a worksheet arranged in a block with row and column headings.

In excel spreadsheet it is possible to fill a formula with row and column headings ie.. formula with labels.

is it possible to do the same with vba6, to easily access data from worksheet?
ie instead of the usual let's say Range("B3"), how can i refer to the cell as by the row heading - Feb, and column heading - "Sales" ie Range("sales" Feb") ?


Thanks
Geetha

Hi Geetha,

Please try this.

Sub Rowandcell()
Dim i As Long

If Cells(i, 9) = "sales" Then
Rows(i).Copy
End If

End Sub

Regards,
Shekar.

Hi Shekar,
Thanks for your interest. but this is the usual way i operate.

i was looking for a way to refer to a cell the way it is referred to in the spreadsheet formula with labels.

Geetha