Hi all,

I have a macro in a worksheet which is trying to find the contents of the last cell which is not blank in a column in a workbook online. So for example at the moment the last cell in Column B which has any entry is B33, B34 and beyond are all empty.

FindCell = 'http://intranet/documents/[Activities.xlsx]Sheet1'!$B$33

The above is the filepath location and the specific range but it may change which is why it needs to look for the last entry in Column B, can anyone help? I tried playing around with worksheet.range etc. but could never get it to work, not sure if this is something simple I am doing wrong/because im trying to access a workbook online or if its because i was just getting the code wrong when trying to find the last value.

Any help would be greatly appreciated!