To apply the macro only on the visible cell (filtered data alone)

Hello everyone,

I got the below code from this forum only, unable to post the link. Due to the warning message "You are not allowed to post any kinds of links, images or videos until you post a few times."

Please Login or Register  to view this content.

The above macro highlights the first occurrence of the word in red font (in column D alone). (Data is found in column D11 to E15000. Range D10 & E10 contains the header). Currently the macro takes the whole data set while highlighting, even when the filter is on and only 15 rows are visible.

Is it possible to find last row of visible cells alone (minus the header) and incorporate into the code. I want the macro to take only the visible cells into consideration while highlighting for first occurrence word. Can anybody please help ?. When i tried to include "SpecialCells(xlCellTypeVisible)", I am always getting an error. "Run time error 13, type mismatch. Please help.