Posted to microsoft.public.excel.programming

oercim

external usenet poster

Posts: 51

comparing strings

Hello, I have a problem. I want to compare string in vba however I couldn't manage.My statemets are like below:

If Sheets("Sayfa1").Cells(1, 1) ="TRUE" Then
Sheets("Sayfa1").Cells(1, 2) = 1
End If

These statements doesnt give error but it doesnt also print "1" cell(1,2) even the cell(1,1)="TRUE.

How can I do this? Thanks a lot.

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
Comparing text strings	Comparing columns with text	Excel Worksheet Functions	5	November 28th 09 07:43 PM
comparing text strings	CG Rosén	Excel Programming	2	September 24th 07 09:08 AM
problem with comparing strings in VBA	[email protected]	Excel Discussion (Misc queries)	2	June 25th 07 11:16 PM
Comparing Formula Strings after Row has been Inserted	ExcelMonkey	Excel Programming	3	May 7th 07 08:32 PM
Comparing slightly different strings	theDude[_18_]	Excel Programming	0	July 30th 05 12:55 AM

All times are GMT +1. The time now is 03:05 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us