Search results for:

Harry's post? I thought that was rather balanced, given other posts we've seen on the subject of Foffa

Can you merge it into a thread with an innocuous first post?

Nah I'd leave it up there. Especially given your position last week of wanting to not give editorial control of threads to companies whose products were under discussion.

Depending on budget I'd go for Sugino Messenger (~£60 new) or Sugino 75 (~£220 new / ~£140 second hand). Then choose correct shimano BB to get the chainline right.

shurely somewhere on denmark street?

Input your specs and see what this says here: http://software.bareknucklebrigade.com/

Incidentally, Paul Royal Flush cranksets are a bit crap IMO, as you can't buy the chainrings separately from the cranksets. So sure, they look cool, but if you wear out the chainring / bash it / decide you want a different size, you have to replace the whole crankset.

Check out Sheldon Brown's site for all the info you need on converting a bike to fixed. There is also tonnes of discussion on here you can find by searching for specific questions. Also, check out the "current projects" thread for support and inspiration.

Good luck!

http://wastedatwork.com/beer/ej6Y0.png

Just read the article. Sounds like it was a pretty fraught time for the band!

More Snowy in old magazines!

Rocking the "naked and a bit fucked up" look in Loose Lips Sink Ships #4 from 2004

http://cornellinsider.com/2010/11/15/hotel-prof-erupts-yawn-outside/

YouTube - Cornell Professor Outbursts at a Student's 'Overly Loud' Yawn

Prick. Good on the students for not ratting.

use google chrome, it's a better browser

@dooks - blogger or wordpress + soundcloud.com :: free

@damo - go for it! I recommend using "option explicit" to force you to declare your variables up front - should make things easier in the long run

I'd take hacking about in Excel over Access any day of the week.

Access will run over your dog and steal your wife.

Fuck Access. Fuck Access in its unstable arse.

You can definitely do all that using VBA. Have a play around with the code I dropped here earlier.

Damo, the code in post 4164 is giving me the chills!

You shouldn't need to invoke conditional formatting from VBA - conditional formatting is a quick & easy way of writing the VBA yourself if you see what I mean.

Cell is coloured red when conditions are not met, coloured "blank" when conditions are met

Try this:

[code]

Sub awesome_code()

If (WorksheetFunction.CountBlank(Range("C3:CG3")) = 1 And Range("AS3").Value = "Method C" And Range("AT3").Value = "") Or (WorksheetFunction.CountBlank(Range("C3:CG3")) = 0) Then

Range("A1").Interior.ColorIndex = 0
Else
Range("A1").Interior.ColorIndex = 3

End If

End Sub

[/code]

Where A1 is the cell getting the colouring action

I'm confused. You're dropping that formula into the cell? Why?

Excel question

've got a row of data
C3:CG3

At the moment I apply the format via a macro with the following
"=AND(COUNTBLANK(C3:CG3)>0"
to cell B3
so that when a blank cell is in the row, cell B3 goes RED.

However. I've twigged that if AU3="Method C" then AT3 can be blank. and that if the only blank cell is AT3 AND AU3 ="Method C" then B3 should not be coloured.

In my head it seems to be something like
"=AND(COUNTBLANK(C3:CG3)>0) BUT NOT IF ((AT3=blank) AND (AU3 = "Method C"))"

what do I need to do to make it correct?
Is it laid out in the correct logic? and what is the correct excel format?

[code]
if,countblank(C3:CG3) = 0) [then] no fill [else] red[/code]

should work

ie. the cell is only not-red when either
(a) there is exactly 1 empty cell in your array c3:cg3, that blank cell is at3, and au3 = "Method C"
or (b) there are no empty cells in array c3:cg3

http://hyperboleandahalf.blogspot.com/2010/11/dogs-dont-understand-basic-concepts.html

This is very funny!

YouTube - Alan

Black Eyes. Got a feeling this is going to be a Dischord day.

1) load up original "peel & peel" logo in your favourite photoshop-esque software package
2) fill the text you want to be see through in a colour that doesn't appear anywhere else in that image (eg fluoro green)
3) copy/paste into word, on top of the picture you want it to be, erm, on top of (note, powerpoint is probably a better programme to use here)
4) set the fluoro green colour of the floating logo to be transparent, as described in the earlier link