For once, I respectfully ask that you do not reply to this thread unless you have a definitive YES or NO answer
- some members do not look at threads which already contain replies - and I would prefer this thread to remain unanswered until someone can give me a categoric YES or NO
I have a very specific need. I am not looking for a workaround. Removing and re-applying the filter is not an option - the filter is complex (and frequently changing!) and applied manually - capturing those values in VBA to re-apply the data filter each time would require an impressive bit of VBA coding - and I do not want to go down that route.
thank you
With data filter applied .RowHeight returns value = 0 in respect of any rows filtered out
With data filter turned off, the row returns to its previous height - Excel therefore holds all the original values somewhere
Can VBA return that original value at the moment when the row is filtered out (whilst the workbook is open)?
(And if so what is the code)
Bookmarks