I often hit the post size character limit.
So every bit of saving of character usage is helpful to me
I often use Rory's Screenshot Tool.
I noticed it had a bit that for every row defined the background colour as white.
I took it out and it seems to have no effect on final output.
So that little change saves a bit of character space for me.
So:-
Taking out the “white background color”.
This is the default background row color, I think. It seems to come out at white anyway, so I took out the explicit “making it white bit”. In long deep tables that will save quite a few characters in the BB Code.
I did this, ‘cos I could
So I did this simple Mod in the Private Function RngToBBC in the mBBCode Normal Code Module, (Basically I just edited out the bit in shown in red)
Code:
'sOut = sOut & vbNewLine & "[tr=bgcolor:" & csROW_BACK & "]"
sOut = sOut & vbNewLine & "[tr]" 'Remove white background for entire row
If bHdr Then sOut = sOut & "[td=bgcolor:" & csHEADER_BACK & "][COLOR=" & csHEADER_COLOR & "]" & rRow.Row & "[/COLOR]
[/td]"
So it used to produce this:
[color=lightgrey]Using Excel 2007 32 bit[/color]
[size=0][Table="width:, class:head"][tr=bgcolor:skyblue][th][COLOR=black][sub]Row[/sub]\[sup]Col[/sup][/COLOR][/th][th][CENTER][COLOR=black]J[/COLOR][/CENTER][/th][/tr]
[tr=bgcolor:#FFFFFF][td=bgcolor:skyblue][CENTER][COLOR=black][b]35[/b][/COLOR][/CENTER][/td][td][/td][/tr]
[/table][/size][size=0][color=lightgrey]Worksheet: [/color][b][color=darkblue]Intercepts[/b][/color][/size]
Using Excel 2007 32 bit
Worksheet: Intercepts
After the small code mod I get this:
[color=lightgrey]Using Excel 2007 32 bit[/color]
[size=0][Table="width:, class:head"][tr=bgcolor:skyblue][th][COLOR=black][sub]Row[/sub]\[sup]Col[/sup][/COLOR][/th][th][CENTER][COLOR=black]F[/COLOR][/CENTER][/th][/tr]
[tr][td=bgcolor:skyblue][CENTER][COLOR=black][b]32[/b][/COLOR][/CENTER][/td][td][/td][/tr]
[/table][/size][size=0][color=lightgrey]Worksheet: [/color][b][color=darkblue]Intercepts[/b][/color][/size]
Using Excel 2007 32 bit
Worksheet: Intercepts
This remains a jolly spiffing super Tool in my opinion. I have erected it in more places and more times than I care to remember. It really is the Doggies best
http://www.excelforum.com/showthread...=3#post4573121
http://www.excelfox.com/forum/showth...0055#post10055
http://excelmatters.com/excel-forums/#comment-199330
Bookmarks