MACRO PROBLEM

verluc · May 22nd, 2002, 03:03 PM

I have a macro with the following line :
If Cells(x, 4).Value > Cells(x, 5).Value Then

The problem is that for the word "then" there must be a another condition "OR" with the text #N/B

Who can inform me?
Many thanks

verluc · May 22nd, 2002, 03:22 PM

Quote:

On 2002-05-22 14:03, verluc wrote:
I have a macro with the following line :
If Cells(x, 4).Value > Cells(x, 5).Value Then

The problem is that for the word "then" there must be a another condition "OR" with the text #N/B

Who can inform me?
Sorry for the question.I have found the solution.
Many thanks

Jack in the UK · May 22nd, 2002, 03:25 PM

can you post you code im sure the VBA boys will get stuck in to it, your post is simply saying

if//////// then /// i guess you want else here but then what.....

James · May 22nd, 2002, 03:27 PM

Hi Verluc,

If [X4].Value > [X5].Value Then
MsgBox" X4 is greater than X5",vbOKOnly + vbExclamation

Regards,
James

May 22nd, 2002, 03:25 PM	#3
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,065	can you post you code im sure the VBA boys will get stuck in to it, your post is simply saying if//////// then /// i guess you want else here but then what..... __________________ Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you"

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 22nd, 2002, 03:03 PM	#1
verluc Board Regular Join Date: Mar 2002 Posts: 1,288	I have a macro with the following line : If Cells(x, 4).Value > Cells(x, 5).Value Then The problem is that for the word "then" there must be a another condition "OR" with the text #N/B Who can inform me? Many thanks

May 22nd, 2002, 03:27 PM	#4
James Board Regular Join Date: Feb 2002 Location: Huntington Beach, CA USA Posts: 327	Hi Verluc, If [X4].Value > [X5].Value Then MsgBox" X4 is greater than X5",vbOKOnly + vbExclamation Regards, James