I tried to post a new thread and was blocked by "Sucor". Any idea why?
I tried to post a new thread and was blocked by "Sucor". Any idea why?
do you have any "<" symbols in the thread?
Ben Van Johnson
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.
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 iconbelow the post.
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.
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.
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks