Hi,

I am facing a problem whereby i am trying to use the lastincolumn function to copy the last value in a column of a workbook into a new workbook. It requires me to open the workbook that I am copying from for it to work or to be updated. Is it possible to use the lastincolumn function without the need to open the workbook that i am copying, that is, to get the last value in a specific column in a closed workbook?