Hi There,

I have just joined.

I came looking for a solution (or two).

I have a spreadsheet with 4 filtered columns. Elsewhere in the sheet, I would like to include 4 cells, which can detect if the filter is active and, if it is, to return the value of the first visible cell of the filtered list. Can anyone a) tell me if this is possible and, b) tell me how to do it.

I have racked my brain, and tried a multitude of things, but nothing seems to do the trick.

I have some experience with macros, and none with VBA, but am willing to try.

Thanks

Terry