L
Lionel H
Having selected a number of cells, I use the following to process them:
Sub Demo1()
Dim myCell
For Each myCell In Selection
‘Do some processing:
Debug.Print myCell.Value
Next myCell
End Sub
This works fine until I select cells across cells hidden by the autofilter
The above macro includes the cells hidden by the autofilter which I do not
want.
I amend my code as follows:
Sub Demo2()
Dim myCell
For Each myCell In Selection
If Not myCell.Hidden Then ‘this line fails – 1004 Unable to get the
Hidden property of the range class
‘Do some processing:
Debug.Print myCell.Value
End If
Next myCell
End Sub
I have used debug watch on myCell and Selection and cannot find an
alternative way of skipping the autofiltered cells.
Can anyone help please?
Sub Demo1()
Dim myCell
For Each myCell In Selection
‘Do some processing:
Debug.Print myCell.Value
Next myCell
End Sub
This works fine until I select cells across cells hidden by the autofilter
The above macro includes the cells hidden by the autofilter which I do not
want.
I amend my code as follows:
Sub Demo2()
Dim myCell
For Each myCell In Selection
If Not myCell.Hidden Then ‘this line fails – 1004 Unable to get the
Hidden property of the range class
‘Do some processing:
Debug.Print myCell.Value
End If
Next myCell
End Sub
I have used debug watch on myCell and Selection and cannot find an
alternative way of skipping the autofiltered cells.
Can anyone help please?