Microsoft Teams Development
Microsoft Teams: A Microsoft customizable chat-based workspace.Development: The process of researching, productizing, and refining new or existing technologies.
3,065 questions
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Hi all,
Can anyone help me please.
when a user selects a range in a filtered sheet and press on a 'do something button'
I want to know the location of only the selected cells within that range
Dim Rng as Range
Dim MM_tbl As ListObject
Set Rng=Selection
for Each Rng in application.selection
' is a cell is in a selection mode
if MM_tbl.range(rng.row,rng.column).SpecialCells(xlCellTypeVisible)=selected then....
next
Thanks a lot
Michel