LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #6   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 417
Default Check Cell Content before continuing...

<<Can you tell me how to stop the Macro if the 'then' condition is met, and
continue if it isn't?

Leave the 'then' condition empty and have code in the 'else' part of the
clause only, or revise the logic as follows:

Sub Test()
If Range("Q44").Value < "Fill in..." And _
Range("F47").Value < Range("AB2").Value _
Then
'Your code here.
End If
End Sub

Except that your OP (original post) said:
<<IF new, then continue macro. IF unchanged, then display error...
--
Regards,
Bill Renaud



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Check if content in cell is an integer prem New Users to Excel 6 May 1st 08 01:54 PM
Check if content in cell is an integer Mike H New Users to Excel 0 May 1st 08 09:53 AM
VBA cell content check Derek Wittman Excel Programming 7 September 6th 06 07:52 PM
text continuing in next row in a merge cell Peyline Excel Worksheet Functions 4 July 10th 06 08:43 AM
How to check a cell for content before running macro. Incoherent Excel Programming 1 October 7th 05 04:42 PM


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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"