Adding an 'And' to a code! 2

[APElliott]

Hello,

I,ve got the code below to stop a code from running if a cell = "".

How do I add to the code?

I want it to exit the sub If ActiveCell.Offset(0, -15) = "" & if If ActiveCell.Offset(0, -13) is greater than 0

If ActiveCell.Offset(0, -15) = "" Then
Exit Sub
Else

Cheers,

Andrew

 

[Bowers74]

If ActiveCell.Offset(0, -15) = "" And _
If ActiveCell.Offset(0, -13) > 0 Then
Exit Sub
Else


Peace!

Mike

Never say Never!!!
Nothing is impossible!!!

 

[Bowers74]

Better practice is:

If isempty(ActiveCell.Offset(0, -15)) And _
If ActiveCell.Offset(0, -13) > 0 Then
Exit Sub
Else

That way you are truely looking if the cell is empty.

I hope this helps!



Peace!

Mike

Never say Never!!!
Nothing is impossible!!!

 

[JohnAcc]

Hi Andrew,

You just need to type in AND

If ActiveCell.Offset(0, -15) = "" And ActiveCell.Offset(0,-13) > 0 Then
Exit Sub
Else
...........

Cheers

John

 

[APElliott]

Thanks Guys

Saved the day again.

The cell has a formula in it that sometimes = 0. Does this count as IsEmpty?

Thanks

Andrew

 

[Bowers74]

No Andrew, that counts as 0

Empty means empty!

Peace!

Mike

Never say Never!!!
Nothing is impossible!!!

 

[xlbo]

[ROFL][ROFL]

Rgds, Geoff
[blue]Quantum materiae materietur marmota monax si marmota monax materiam possit materiari?[/blue]
Want the [red]best[/red] answers to your questions ? faq222-2244