What is the proper syntax

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have the following in a worksheet change event

If Target.Offset(0, 1).Value > Target.Offset(-1, 1).Value And _
Target.Offset(0, 2).Value Is Not blank And _
Target.Offset(0, 3).Value Is Not blank And _
Target.Offset(0, 4).Value Is Not blank And _
Target.Offset(0, 5).Value Is Not blank And _
Target.Offset(0, 6).Value Is Not blank And _
Target.Offset(0, 7).Value Is Not blank Then

end if

I'm not sure this is correct. I need to check to see that these cells are
blank and if they aren't, I want to do something else.

Thanks in advance
 
If Target.Offset(0, 1).Value > Target.Offset(-1, 1).Value And _

Application.CountBlank(Range(Target.Offset(0,2)),Target.Offset(0,7))) =
0 Then

Charles Chickering
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Deleting specific information 3
Junp start my Select Case Macro 12
VBA triggers on tabkey 8
Why are the two codes below not getting the right formula for myworksheet event change formula? 2
BeforeDoubleClick Event not working 2
macro code to a shared file 2
Checking when target.values are empty. What am I doing wrong? 1
How to make sub handle more than 1 cell ? 4

Back
Top