ExcelBanter
(
https://www.excelbanter.com/
)
-
Excel Programming
(
https://www.excelbanter.com/excel-programming/
)
- -
If then statement with two true conditions
(
https://www.excelbanter.com/excel-programming/313720-re-if-then-statement-two-true-conditions.html
)
Don Guillett[_4_]
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 :)
All times are GMT +1. The time now is
12:17 PM
.
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com
