+ Reply to Thread
Results 1 to 3 of 3

How to use Search, find last data point in column then select from that to ActiveCell

  1. #1
    Registered User
    Join Date
    05-29-2010
    Location
    West
    MS-Off Ver
    Excel 2007
    Posts
    7

    How to use Search, find last data point in column then select from that to ActiveCell

    How to find last data point in Column Then select from ActiveCell to last data point using a range method?

    Now I know that I could have probably found the answer to that question by searching the forums, which I did.

    The problem is that the search feature removes half of my words because they are too common. The result of this seems to be that my question loses its meaning and I get hundreds of results. Any tips on how to use the search here would be appreciated.

    Last questions. I keep having to manually subscribe to these posts, anyway to just make it automatic? Anyway to set it such that it emails everytime there is a response and not just for the first response?

    The answers to these questions would be very useful then I can contribute and do more research on my own.



    Thx

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,241

    Re: How to use Search, find last data point in column then select from that to Active

    To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

    If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

    Doing this will ensure you get the result you need!

  3. #3
    Registered User
    Join Date
    05-29-2010
    Location
    West
    MS-Off Ver
    Excel 2007
    Posts
    7

    Re: How to use Search, find last data point in column then select from that to Active

    That is what I will do in the future. I didnt realize peopel would be willing to download .xls files here. Pretty cool. I worked on my first VBA program and posted it below.
    How or what you would have done differently would be appreciated. Thx

    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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