Naming cells in filtered tables

I'm trying to name a cell so that I can replace the range H8 in the code below with the name since it may not always be row 8 that the code filters to. But when I tried this, it still gives me a R and C reference of 8. Ultimately what I'm trying to do is filter the table to 1121000000 and name the cell directly to it's right regardless of what row it happens to be at the time.

Please Login or Register  to view this content.

Hi narrowgate88;

If you just want to name the cell next to the cell in the 4th column of table 3 that contains 1121000000, you don't need to autofilter.

Please Login or Register  to view this content.