Servers still crashing I see. I managed to make a few triple posts today. Still having problems?
Servers still crashing I see. I managed to make a few triple posts today. Still having problems?
Be fore warned, I regularly post drunk. So don't take offence (too much) to what I say.
I am the real 'Napster'
The Grid. A digital frontier. I tried to picture clusters of information as they moved through the computer. What did they look like? Ships? motorcycles? Were the circuits like freeways? I kept dreaming of a world I thought I'd never see. And then, one day...
If you receive help please give thanks. Click the * in the bottom left hand corner.
snb's VBA Help Files
On occasion![]()
Seems to be struggling a bit today.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
It seems ok for me so far today, good to see you again JD
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Real life interferes with all of us LOL
Last edited by FDibbins; 12-23-2015 at 08:03 PM.
Absolutely!!! And you are Admin now, I hope it is not too much work?
It has it's moments, and the pay is great (not)![]()
Can't post again. WTF
Can someone please tell me why can't post n the VBA section, but can in the water cooler?
I can't post here,
http://www.excelforum.com/excel-prog...worksheet.html
I am trying to update some code I left out and it won't let me post.
Error say I can't post HTML code. I am not even trying to post HTML code.
Hi Dave,
New management - new screwups![]()
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
Looks like the forum is down again.
JD, I just posted to that thread with out a problem. I must say that of late, I have noticed that VBUL doesnt seem to like the > or < signs if used together, could that be the problem?
Can you post here and I can try and copy it to there?
It won't let me post even short code WITHOUT code tags.
Edit: I took out the symbol you suggested. And I was able to post.
But does me no good as the code below is now incorrect because I need the greater than symbol in front of TODAY
![]()
Please Login or Register to view this content.
EDIT 2: This is the entire code without the symbol.
But it will let me post "<" here, but not in code.![]()
Please Login or Register to view this content.
Last edited by JapanDave; 01-01-2016 at 03:59 AM.
Hi Dave,
Happy New Year.
I've also had problems recently with the angle brackets - try it with a space either side of the symbol.
Hope this helps.
Pete
If it is like some other sites you only need the space after the < symbol (and claimed only if followed by a non-numeric character but I have never tested this).
A bit strange though as I thought it only happened when Html was allowed but obviously not.
It should only apply to the < symbol and not the > symbol.
If my solution worked (or not) please let me know. If your question is answered then please remember to mark it solved
Computers are like air conditioners. They work fine until you start opening windows. ~Author Unknown
@ JapanDave
Just lurked in passing this Thread.... so Just a minor bit of passing Info...
The problem you had ( with < ) is probably one of the strange combinations of characters that the Scurri Security thing blocks ( and typically says something about a HTML problem, as you experienced ).
It Comes up a lot, for example:
http://www.excelforum.com/the-water-...ml#post4226385
http://www.excelforum.com/suggestion...xcelforum.html
( and I expect like many of ExcelForum’s problems it has been here ages, long before my time...I just lurked a few old threads from 4 years ago! Seen a few problems I thought were just in the last year or so......
http://www.excelforum.com/suggestion...ml#post2704574
http://www.excelforum.com/the-water-...ml#post2696661
http://www.excelforum.com/the-water-...ml#post2699602
http://www.excelforum.com/the-water-...ml#post2700282
.........--)
_.....................................................
Anyways,
In your particular case it appears the “magic” combination that cause the problem is a combination of a < and 4 characters . These characters can be any combination of numbers and "normal" characters.
A space after the < will cure it and also:.......
_(i) A Space anywhere in the 5 character total
< Today
<T oday
<To day
<Tod ay
<123 4
< 1234
<1 234
<12 34
<123 4
or
_(ii) an "unusual character", for example % & * etc. – The [ is a good one to consider..
<Tod[ay
That last one leading to the "Black Colour Trick"
<Today
-this one above was made to look in the Forum Editor as
<Tod[COLOR="#000000"]a[/COLOR]y
Or
<Tod[COLOR=black]a[/COLOR]y
In other words i made the colour of __a__ black
http://www.excelforum.com/suggestion...ml#post4295096
_ - the “space trick” is good in a code window, - as when you copy the code to a VB Editor Code Window the VB Editor will usually take the space out.
_ - the “black colour trick” is the one to go for if you want to show and allow to be copied something exactly as you have it in the Forum Editor.. – as when your copy, you just get what you see, not the BB Code bit that makes the black colour.
Just a bit passing info, may help in the future..
Alan
Last edited by Doc.AElstein; 02-02-2016 at 06:32 AM.
'_- Google first, like this _ site:ExcelForum.com Gamut
Use Code Tags: Highlight code; click on the # icon above,
Post screenshots COPYABLE to a Spredsheet; NOT IMAGES PLEASE![]()
http://www.excelforum.com/the-water-...ml#post4109080
https://app.box.com/s/gjpa8mk8ko4vkwcke3ig2w8z2wkfvrtv
http://excelmatters.com/excel-forums/ ( Scrolll down to bottom )
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks