+ Reply to Thread
Results 1 to 2 of 2

VBA to select the previous visible cell

  1. #1
    Forum Contributor
    Join Date
    07-17-2012
    Location
    India
    MS-Off Ver
    Excel 2016
    Posts
    715

    VBA to select the previous visible cell

    Hi,

    Please Login or Register  to view this content.
    What is wrong with above code? I am not able to select previous A15 cell, when macro is selected from C1 cell ( B row is filtered to hide )

    Please assist.

    Thanks
    Shiva
    Keep the Forum clean :


    1. Use [ code ] code tags [ /code ]. It keeps posts clean, easy-to-read, and maintains VBA formatting.
    2. Show appreciation to those who have helped you by clicking * Add Reputation below their posts.
    3. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 insider Version 2507 Win 11
    Posts
    24,921

    Re: VBA to select the previous visible cell

    Try this:

    Please Login or Register  to view this content.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Code to select visible cell range only
    By mukeshbaviskar in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-23-2013, 03:05 AM
  2. Select Cell In Center Of Visible Range
    By Spencer in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-31-2011, 01:53 PM
  3. Select visible cell using Offset
    By praveen_khm in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-22-2011, 10:56 AM
  4. VBA Select Previous Cell + Current
    By tpowell55 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-30-2010, 01:05 PM
  5. Select cell content from visible rows.
    By jeff p in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-15-2009, 02:56 PM

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