Hi'
I have the following code: (made by Murad5 on this board)
Sub marker()
Dim myRange As Range, cel As Range
Set myRange = Selection
For Each cel In myRange
cel.Offset(0, 1).Value = "x"
Next
End Sub
I would like the functionality to work, when the cells marked could be in a filtered range. As it is today every cell is updated - and not only those shown on screen.
I hope you can help me out
Best wishes
Christian
I have the following code: (made by Murad5 on this board)
Sub marker()
Dim myRange As Range, cel As Range
Set myRange = Selection
For Each cel In myRange
cel.Offset(0, 1).Value = "x"
Next
End Sub
I would like the functionality to work, when the cells marked could be in a filtered range. As it is today every cell is updated - and not only those shown on screen.
I hope you can help me out
Best wishes
Christian