Filter and Copy Visible cells based on condition

**kittu55** · 03-06-2017, 11:10 AM

Hi all,

Im using a macro to copy and paste visible cells after filtering the data into a new sheet. However, A blank sheet is also getting created as and when there is no data meeting the filtered criteria. I want the sheet to be created only when there is data existing in the master sheet.

Below is the code im using and i don't know where im doing wrong.

Any help is greatly appreciated. Thanks in advance

Please Login or Register  to view this content.

**LeoTaxi** · 03-06-2017, 11:53 AM

Try

Please Login or Register  to view this content.

Kind regards
Leo

**kittu55** · 03-06-2017, 12:16 PM

Hi Leo,

Thanks for the response. this is working fine.

Can you please let me know why the code posted by me is not working

Thanks

**LeoTaxi** · 03-06-2017, 12:22 PM

No

i think the SpecialCells(xlCellTypeVisible).Count don't work

Kind regards
Leo

**kittu55** · 03-06-2017, 09:31 PM

Thanks Leo.

Filter and Copy Visible cells based on condition

LinkBack

Thread Tools

Rate This Thread

Display

Filter and Copy Visible cells based on condition

Re: Filter and Copy Visible cells based on condition

Re: Filter and Copy Visible cells based on condition

Re: Filter and Copy Visible cells based on condition

Re: Filter and Copy Visible cells based on condition

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Filter data and copy visible cells based on criteria

Can you find the quartile of an array based on a condition and using only visible cells??

Advanced Filter Copy visible cells only

[SOLVED] Copy Filter Data and paste it on another workbook with special cells(Only Visible Cells)

Copy visible cells from Row B paste to Row A in filter mode

Looping through a Range,Filter and copy visible cells

Copy to Visible cells after filter

Bookmarks

Bookmarks

Posting Permissions