Correct syntax

[Paragons]

Im really bad at understanding VBA, so bear with me as I'm just using a shotgun approach.

Why is this wrong?

Please Login or Register  to view this content.

Im just trying to have my macro compare the values in cells v5 and v23 and if they are not equal Im going to end the macro.

[avveerkar]

Im really bad at understanding VBA, so bear with me as I'm just using a shotgun approach.

Why is this wrong?

If cell.Value("v5") <> cell.Value("v23") Then
MsgBox "Finished"
End If

Im just trying to have my macro compare the values in cells v5 and v23 and if they are not equal Im going to end the macro.

Please Login or Register  to view this content.

But these are basics. I suggest you go through the help file which is very good and gives a lot of information. All the best

A V Veerkar

[Tarball]

Why is this wrong?
Originally Posted by Paragons
Im really bad at understanding VBA, so bear with me as I'm just using a shotgun approach.

Why is this wrong?

If cell.Value("v5") <> cell.Value("v23") Then
MsgBox "Finished"
End If

Because when you say "cell" you do not provide any location of what cell you are attempting to compare. Everything in MS-Excel is a range (even a single cell) and you must specifiy the correct range or range address before attempting to compare or modify the cells value.