+ Reply to Thread
Results 1 to 8 of 8

Testing Sucor Block

Hybrid View

  1. #1
    Forum Contributor
    Join Date
    07-23-2016
    Location
    Texas
    MS-Off Ver
    2016
    Posts
    274

    Testing Sucor Block

    I tried to post a new thread and was blocked by "Sucor". Any idea why?

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,960

    Re: Testing Sucor Block

    do you have any "<" symbols in the thread?
    Ben Van Johnson

  3. #3
    Forum Contributor
    Join Date
    07-23-2016
    Location
    Texas
    MS-Off Ver
    2016
    Posts
    274

    Re: Testing Sucor Block

    Not sure as when I "x" out the succor blockage, my session with the forum ended and the message I was trying to post was lost. I tried again with what I thought was the same text which also had a code segment and it worked ok and the thread was posted.

  4. #4
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Testing Sucor Block

    As Ben alludes if you have chevrons in a formula put a space either side. I've encountered this behaviour many times but it doesn't seem consistent - no idea why?
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  5. #5
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,352

    Re: Testing Sucor Block

    I also have had problems trying to use the "chevrons" of Greater Than or Less Than symbols.

    I now use GT and LT instead of those arrow heads as this site seems to not accept my post if I use the symbol(s).

    I too have no idea why.
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  6. #6
    Forum Guru bakerman2's Avatar
    Join Date
    10-03-2012
    Location
    Antwerp, Belgium
    MS-Off Ver
    MSO Home and Business 2024
    Posts
    7,338

    Re: Testing Sucor Block

    From what I've learned here Securi firewall sees this as html tags and it doesn't like that.
    Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
    You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.

  7. #7
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Testing Sucor Block

    Quote Originally Posted by bakerman2 View Post
    From what I've learned here Securi firewall sees this as html tags and it doesn't like that.
    .. but infuriatingly not all the time. i.e. at the moment
    =1<>2
    is being accepted

  8. #8
    Forum Guru bakerman2's Avatar
    Join Date
    10-03-2012
    Location
    Antwerp, Belgium
    MS-Off Ver
    MSO Home and Business 2024
    Posts
    7,338

    Re: Testing Sucor Block

    But tried to post this a few days ago (without the spaces) and I also got thrown out.
    Maybe a combination of ....

    Sub DelRows()    
        With ActiveSheet
            .Cells(1).CurrentRegion.AutoFilter 1, " < 13420000000", xlOr, " > 16000000000"
            .AutoFilter.Range.Offset(1).SpecialCells(12).EntireRow.Delete
            .AutoFilterMode = False
        End With
    End Sub

+ 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. Replies: 5
    Last Post: 10-09-2012, 10:44 AM
  2. Replies: 2
    Last Post: 06-22-2010, 07:55 AM
  3. [SOLVED] testing for #NA with VBA
    By Tim Kredlo in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-25-2005, 05:06 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1