Results 1 to 22 of 22

Underlying row height

Threaded View

  1. #1
    Forum Expert
    Join Date
    11-22-2016
    Location
    Cornwall,UK
    MS-Off Ver
    office 365
    Posts
    4,240

    Underlying row height

    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)
    Last edited by kev_; 04-22-2017 at 04:24 AM.
    Click *Add Reputation to thank those who helped you. Ask if anything is not clear

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 0
    Last Post: 02-13-2016, 03:31 AM
  2. Replies: 1
    Last Post: 09-25-2015, 11:49 AM
  3. Replies: 4
    Last Post: 03-21-2015, 08:18 PM
  4. Replies: 2
    Last Post: 01-12-2015, 02:52 PM
  5. Macro to autofit row height, and then reduce back to original height
    By LesleyRicco in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-03-2013, 09:12 PM
  6. Replies: 17
    Last Post: 02-25-2009, 10:09 AM
  7. Replies: 3
    Last Post: 04-23-2007, 01:55 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1