Posted to microsoft.public.excel.programming

[email protected] hittingtime@gmail.com is offline

external usenet poster

Posts: 5

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.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
vba using the OR operator	Mona	Excel Programming	8	February 27th 07 11:29 PM
Like operator	marianne	Excel Programming	6	June 3rd 06 09:28 PM
XOR Operator - How?	Randy Brown	Excel Discussion (Misc queries)	3	April 8th 06 09:47 PM
OR Operator	Freddy	Excel Worksheet Functions	2	April 17th 05 06:11 PM
Like Operator	Donald[_3_]	Excel Programming	8	June 29th 04 03:22 AM

All times are GMT +1. The time now is 05:41 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us