Find last cell in column B, message box contents of column A

[Nu2Java]

Find last cell in column B that contains data, message box contents of column A in the same row? Thanks for any help.

[nathansav]

activesheet.cells(ActiveSheet.Range("B10000").End(Xlup).row,1)

[Roger Govier]

Hi

Try the code below

Please Login or Register  to view this content.

[/CODE]

[Nu2Java]

Thanks for both options... They work great!!!