Results 1 to 6 of 6

Help with VBA stuff. Range list causing "skip" in cursor to end of cell range

Threaded View

  1. 01-10-2020, 09:54 AM #4
    PCI
    PCI is offline
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    MS 365 Office Suite
    Posts
    5,085

    Re: Help with VBA stuff. Range list causing "skip" in cursor to end of cell range

    As a quick answer (NOT tested ), I will suggest to change your IFs with next code, avoid Selection

    Old
           If Range("J4") = "Yes" Then
            Rows("6:18").Select
            Selection.EntireRow.Hidden = False
            Range("J4").Select
        End If
    New
            If Range("J4") = "Yes" Then _
            Rows("6:18").EntireRow.Hidden = False
    Last edited by PCI; 01-10-2020 at 09:56 AM. Reason: Typo
    - Battle without fear gives no glory - Just try
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] This line of code is causing an error message "Autofilter method of range class failed"
    By hadleedog in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-04-2018, 03:58 AM
  2. VBA - Excel 2013 - WorksheetFunction.CountBlank
    By dude6571 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-29-2017, 05:33 PM
  3. [SOLVED] Calculating a percentage of "Y" and "N" in dynamic cell range
    By InkyDrinky in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 01-30-2016, 01:35 PM
  4. if Range("A1") = "Mike" Then Range("A1") = "michael" Then Exit Sub
    By a8015945 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-30-2013, 10:08 AM
  5. reference date above last cell in range displaying "1" or "2"
    By leeroyrooney in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-20-2013, 05:41 PM
  6. [SOLVED] Find expression causing "Subscript out of range" error
    By aseret in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 07-08-2013, 12:05 AM
  7. [SOLVED] While Using Value from Range D3:D in String, if (D, x) = "" doesnt skip to next row??
    By Spyderz in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 10-28-2012, 01:59 PM

Tags for this Thread

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1