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

**PCI** · 01-10-2020, 09:54 AM

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

**NASANASA** · 01-10-2020, 10:19 AM

Perfect, thanks PCI, that worked.

Appreciate it.

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

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

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

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

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] This line of code is causing an error message "Autofilter method of range class failed"

VBA - Excel 2013 - WorksheetFunction.CountBlank

[SOLVED] Calculating a percentage of "Y" and "N" in dynamic cell range

if Range("A1") = "Mike" Then Range("A1") = "michael" Then Exit Sub

reference date above last cell in range displaying "1" or "2"

[SOLVED] Find expression causing "Subscript out of range" error

[SOLVED] While Using Value from Range D3:D in String, if (D, x) = "" doesnt skip to next row??

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions