Second Last Used Cell In Column

  • Re: Find Value Of Non-blank Cell


    Hi
    Try this, I have not tested it



    See [luc]*[/luc] and [v]*[/v]


    HTH


    Robert

  • Re: Find Value Of Non-blank Cell


    Hi Raynon, Robert


    use



    Wigi

    Regards,


    Wigi


    Excel MVP 2011-2014


    For more Excel memes: visit http://www.wimgielis.com ==> English articles ==> Excel memes


    -- Topics without [CODE] tags or a meaningful topic title, will be neglected by me (and probably many others as well) --

  • Re: Find Value Of Non-blank Cell


    Is this better



    Robert

  • Re: Find Value Of Non-blank Cell


    Robert


    you shoud change


    [vba]Offset(1, 0)[/vba]


    into


    [vba]Offset(-1, 0)[/vba]


    Wigi

    Regards,


    Wigi


    Excel MVP 2011-2014


    For more Excel memes: visit http://www.wimgielis.com ==> English articles ==> Excel memes


    -- Topics without [CODE] tags or a meaningful topic title, will be neglected by me (and probably many others as well) --

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!