Row counter

Hello all, currently trying to get this code:

Please Login or Register  to view this content.

to work, I would like it to count the rows on sheets 1 and 3 and compare it to a cell in sheet 2, and if it is okay continue, if it is not throw an error message.
Is this the correct method of doing it? Can anybody help?

Thank you.

Regards,
Usman.

You do not need the set before rowcount because rowcount is not an object.
There would be no point of turning ws2.Range("A55") into ws2.Range("A55").row since it is obvious that ws2.Range("A55").row = 55.
<> means not equal, and so: If RowCount <> 55 then

Hello, thank you for the reply.

The row number will be determined by a value inside a cell. Inside Cell A55 there will be a value such as 11, 38, 4838 etc.

How would that affect it?

Regards,

Usman.

My mistake.

Assuming you set the ws2 to equal a worksheet, then

In that case: If Not ws2.Range("A55") = RowCount Then should work.
As would: If ws2.Range("A55") <> RowCount Then, they should mean the same thing.

How about:

Please Login or Register  to view this content.