probably need a little more information as to what you're trying to accomplish:

sub test
dim ws as worksheet
set ws = worksheets("Sheet1")
if ws.range("A1") 0 then
'do something
end if
end sub
--


Gary


wrote in message
ups.com...
Hi, All:
I have A1="9" B1="'0" B2="'=1". B2="'<1"........

How can I reference them in VBA, for example, I want to check if A10
or not. I want to use A1 and B1 directly. How can I do that in VBA
I tried

if cells(1, 1) & cells(1, 2) then
.........
end if


It doesn't work. Any one knows how to handle this? Thanks.