Variable (row number) in IF formula in macro

[RC-AMG]

Version: Excel 2016

Hi there,

I can't figure how to include a variable row number in an IF formula.

I use this to get the last row in OtherFile|Sheet1 and create variable LastRow.

Please Login or Register  to view this content.

I then want create an IF formula in the current cell. The IF formula says "if B2 is > the last B cell in OtherFile.xlsx|Sheet1, then return 'New', otherwise; 'Old'".

Please Login or Register  to view this content.

So essentially I want a formula that would replace

Please Login or Register  to view this content.

with

Please Login or Register  to view this content.

Any pointers would be much appreciated!

Thanks.

[CAntosh]

Generally, the rule is to break the quotation, insert your variable with ampersands, then resume the quotations, so try:

Please Login or Register  to view this content.

[RC-AMG]

Perfect; that worked! Thank you so much.