Hello all and Thank you in advanced
I am trying to select all visible cells in a column that has been filtered. The "Delta_length" variable is 56 and when the column is filtered how i want it there are exactly 56 rows. But when i pass through "Range(ActiveCell.Offset(0, 0), ActiveCell.Offset(Delta_length, 0)).SpecialCells(xlCellTypeVisible).Select"
I get a selection from the first visible cell down 56 rows of the WHOLE worksheet, not the filtered rows like I require. Please help me identify how i can make the range work only on the visible filtered cells. ***The "Delta_length" variable may not be 56 next time i run this report.
[VBA]Dim Delta_length As Long
Delta_length = Range("AQ1").Value
'Next Portion locates first Visible cell in the filtered column
Do Until ActiveCell.EntireRow.Hidden = False
'Next portion should select from first visible cell in filtered column 56 visible rows down. But does not
Range(ActiveCell.Offset(0, 0), ActiveCell.Offset(Delta_length, 0)).SpecialCells(xlCellTypeVisible).Select[/VBA]