data = Range("A1:E1").Cells(1,2).Value

or just

data = Range("B1").Value


--

HTH

RP
(remove nothere from the email address if mailing direct)


"TAM" wrote in message
. uk...
Can you please tell me if it is possible to return a value of say the
second
cell (B1) from the following statement...

Dim data As Variant

data = Range("A1:E1").Value

I have tried numerous ways but can not get the value of each cell in the
range which I need to examine before actioning

Thanks

TAM