Hi
Is there a way I can return the last cell in a certain column in an autofiltered list? Basically I want a function that will return the first cell in the column, the last cell in the column, and then calculate the difference between the two cells - but the sheet is autofiltered. Am I making any sense?

Thanks
G