Copy to Visible cells after filter

**vandanavai** · 08-23-2009, 10:54 AM

Hello

I need Vb code to do following
1) I have data in A18:F5000
2) I have filtered it based on Column D
Up to this level I could write vb code using recording macro.
Now I will Put formula in G18 and want to copy it to G19:G5000 but only to visible cells after filter.

Plese help. Hoe to go about this?

**royUK** · 08-23-2009, 12:38 PM

Your recorded code will need editing to something like this. I have assumed the header row is Row 1.

Please Login or Register  to view this content.

**vandanavai** · 08-23-2009, 01:29 PM

Hello

Thanks for help.
It seems bit complicated.

Copy to Visible cells after filter

LinkBack

Thread Tools

Rate This Thread

Display

Copy to Visible cells after filter

Re: Copy to Visible cells after filter

Re: Copy to Visible cells after filter

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions