Vba to name a active cells in a column

[Revathi kannan]

Hi all,

I have the following code which will filter the columns as per my requirement but after filtering the columns i need to name the active cells as "Ship" in the column "Remarks" based on the used range column A. Please assist. Refer the snapshot for the output.

Snapshot 1.PNG

Please Login or Register  to view this content.

[XLent]

references etc aren't altogether clear but, in essence, once filters are applied iterate the areas in the visible range

Please Login or Register  to view this content.

you would likely want an error handler in there, should there be no visible rows (aside the header) - i.e. nothing matches filter

[Revathi kannan]

Thanks a lot. It is working fine.. But the "Ship" has been applied throughout the entire column which is till the row 100000 but i need to apply the "Ship" only for the filtered range which based on column A.

[Sintek]

Insert this after the filter...Change J to your Column...

Please Login or Register  to view this content.

Edit eg...

Please Login or Register  to view this content.