Consulting

Results 1 to 2 of 2

Thread: Select last cell with the data in the column/range of cells - only visible datas

  1. #1
    VBAX Regular
    Joined
    Aug 2014
    Posts
    6
    Location

    Select last cell with the data in the column/range of cells - only visible datas

    Hi,
    I have used the following macro: www excel-easy.com/vba/examples/from-active-cell-to-last-entry.html
    what does works however this macro still select 'empty' cells that contains formula showing "" (blank) if false.
    How can I programe this to select only 'visible' datas?

    Test file attached: starting with A1 going down I wish to select only numbers we can actually see, not the formulas cells underneath.
    I will have to change the range a lot as weel (instead having A1 I may need to have E1:N40 etc).

  2. #2
    VBAX Contributor D_Marcel's Avatar
    Joined
    Feb 2012
    Location
    São Paulo, Brazil
    Posts
    115
    Location
    PENGUIN,

    Can you please send a sample? The file wasn't attached.

    Regards,

    Douglas
    "The only good is knowledge and the only evil is ignorance". Socrates

Posting Permissions

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