View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] hittingtime@gmail.com is offline
external usenet poster
 
Posts: 5
Default How to use operator in cells

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.