+ Reply to Thread
Results 1 to 3 of 3

Macro needed to select visible cells

Hybrid View

  1. #1
    Forum Contributor
    Join Date
    04-21-2009
    Location
    England
    MS-Off Ver
    Excel 2016
    Posts
    710

    Macro needed to select visible cells

    Hi All, can someone provide me with the code needed to select visble cells based on a filter (cell B1) - being "today"

    The important part is skipping to the next part of the macro is no selections are found (currently the macro selects the entire workbook).

    I've spent 5 hours trying to work this out this morning and its beaten me - so thanks in advance

  2. #2
    Valued Forum Contributor
    Join Date
    02-09-2012
    Location
    Mauritius
    MS-Off Ver
    Excel 2007
    Posts
    1,055

    Re: Macro needed to select visible cells

    Hi

    Explain with a sample file and data...
    Click *, if my suggestion helps you. Have a good day!!

  3. #3
    Forum Contributor
    Join Date
    04-21-2009
    Location
    England
    MS-Off Ver
    Excel 2016
    Posts
    710

    Re: Macro needed to select visible cells

    Please see atttched, as you can see there are no cells with date = today, so the filter should not find any data to copy.

    If ther filter was set for = yesterday it should find 7 rows and copy A:R for these 7 rows
    Attached Files Attached Files

+ 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