How can I change this codestage for GetWorksheet to only get visibly values?
To read only visible data how would this codestage look like?
Dim ws as Object = _
GetWorksheet(handle, workbookname, worksheetname, False)
' Do we have a sheet?
sheetexists = ws IsNot Nothing
' No sheet? No entry.
If Not sheetexists Then Return
ws.Activate()
worksheetCollection = GetWorksheetUsedRangeAsDataTable(ws.UsedRange, True)
Anwser from @Nilesh Jadhav is to use
"Ws.Cells.SpecialCells(xlCellTypeVisible)"
Best Regards
Atli
