Menu

If then statement with two true conditions

Search this Thread

#1

Report Post

Posted to microsoft.public.excel.programming

Don Guillett[_4_] Don Guillett[_4_] is offline

Don Guillett[_4_] is offline

external usenet poster

Posts: 2,337

Default

If then statement with two true conditions

glad to help

--
Don Guillett
SalesAid Software

"gaba" wrote in message
...
Don,
Thank you Thank you Thank you
Just what I was looking for.
Thanks for your fast answer!

gaba :)

"Don Guillett" wrote:

try this instead. You must have each condition specified and properly
spell
offset.

If ActiveCell < "Li" and activecell < "Sc" and _
activecell < "Rh" and activecell < "Ho" and _
activecell < "Kr" and ActiveCell.Offset(0, 2)0 Then
Range("E82", "F82").Copy Destination:=ActiveCell.Offset(0, 3)
End If

--
Don Guillett
SalesAid Software

"gaba" wrote in message
...
Hi everybody,
I'm trying to make this work without too much success. Is there any
other
way to do it?

If ActiveCell.Ofsset(0, 0).Value < "Li" < "Sc" < "Rh" < "Ho" <
"Kr"
And
ActiveCell.Ofsset(0, 2).Value "0" Then

Range("E82", "F82").Copy Destination:=ActiveCell.Offset(0,
3)
End If

Any help would be appreciated
--
gaba :)

Reply With Quote

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to 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
if any of 3 conditions is true, then answer is true	inthestands	Excel Worksheet Functions	5	November 16th 06 12:02 AM
how to use true or false conditions	buff	Excel Discussion (Misc queries)	2	May 21st 06 11:34 PM
Returning a Value if 3 Conditions are True	brownie224	Excel Worksheet Functions	5	May 11th 06 11:54 PM
Count Occurances if two conditions true	Ed Gregory	Excel Worksheet Functions	5	September 8th 05 07:26 PM
Count if 2 conditions are true	Thrava	Excel Worksheet Functions	2	July 21st 05 01:56 AM

All times are GMT +1. The time now is 01:58 PM.

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement