Struggling here.
I need to be able to get the actual row numbers of non contiguous selection on one sheet of a workbook - preferably via a loop. The rows each include a sparkline.
The Selected rows will then be deleted.
I can then use that number to relate to the sparkline data column on another sheet in order to delete the columns within the same loop.
It's the extraction of actual row numbers from the selection that I am struggling with.
Any links/pointers appreciated
I need to be able to get the actual row numbers of non contiguous selection on one sheet of a workbook - preferably via a loop. The rows each include a sparkline.
The Selected rows will then be deleted.
I can then use that number to relate to the sparkline data column on another sheet in order to delete the columns within the same loop.
It's the extraction of actual row numbers from the selection that I am struggling with.
Any links/pointers appreciated