Hi Catalin,
Your filtered range could be referenced thus:
ActiveSheet.AutoFilter.Range.SpecialCells(xlCellTy peVisible)
---
Regards,
Norman.
"cata_and " wrote in message
...
Hi everybody,
Please help me with the following problem:
I have a range with abt 850 rows and 17 columns. I need to hide some of
them based on a criteria (which I can do it with VBA or autofilter) and
then I need to number (1,2,3 ....) the visible rows only (to create a
list and print it)
I create a VBA procedure which do this by looping through one column of
the range, checking which cells are visible and assigning a number to
another column, in order, only to the visible rows.
The problem is that this procedure takes too long and the computer
behaves like I have at least 65000 rows full of data. Imagine that
there are only 850 rows. I heard that can be done much faster by
assigning the range to an array.
Is there anyone who can give me a tip?
Thanks in advance
Catalin
PS
I have a pentium 4 with 256 MB RAM and Excel 2002.
---
Message posted from http://www.ExcelForum.com/