finding and going to the middle row of a column in a table

Hi I have a large column and would like for quick navigation purposes to go to the middle of the visible number of rows in the column however with the code I have written its gives me an 'object required' error. what is it that I am missing?

Thanks

Please Login or Register  to view this content.

that was it Debraj Roy! Thanks.
ah that's an interesting alternative Norie, I'll experiment with that. thanks

Whilst were here how would I count the number of visible rows for a collapsed/filtered column as the previous formula will to go the same middle row regardless of whether the column is filtered to show fewer rows?

thanks

Regarding the last question, I've tried the code below

Please Login or Register  to view this content.

however of course this does find the middle number of the visible row count however but that actual row number is different.

youre right Norie! it works great. thanks.