Ignore the hidden rows from Count

[Apple Ling]

Hi,

I need to split the master copy to different sheets for 50 records each. There is hidden rows in the master copy. The code below is able to split the data but the no of records for each sheet is depends on the hidden rows. For examples, the second sheet will less than 50 records if there is a hidden row between. I need each sheet must has 50 records regardless the hidden records. I hope someone can help

Thanks,
Ling

Please Login or Register  to view this content.

[haripopuri]

While copying, copy records of 50 SpecialCells xlCellTypeVisible cells

[JBeaucaire]

I would do it this way:

1) Have your macro apply the filter,
2) Copy all visible data and paste into a new temporary sheet, this eliminates the hidden rows
3) Let your macro run in the temp sheet to parse the data out
4) Delete the temporary sheet
5) Remove the filter

[Apple Ling]

I manage to solve the problem. Thank you