Specific text or number to visible column depending upon filter

[jimpatel1993]

Hi,

Thanks for looking at my post.

I have below code which does,

1. Filter column 33 to specific criteria
2. Filter column 34 to specific criteria
3. Then enter value as "1111" only to visible cells in column 35 (AI Column)

But unfortunately the code is not working as I am doing something wrong. Can any one point out where I am going wrong please.

Much appreciate your help

Thanks,
Jim

[nankw83]

Hi Jim,

Try below code ...

Please Login or Register  to view this content.

[jimpatel1993]

Perfect.

Thanks a lot for your help

[nankw83]

Glad to help & thanks for the added Rep+