Search results for:

So im about to head to Morocco, as its middle of summer and sahara should I go for an Sunny 22 sort of rule, or will sunny 16 be fine? Also as I understand it typically a decrease of one stop in shutter speed and increase of one stop in aperture will even out?

Wheres the cheapest place to get film? Im going on holiday on wednesday so preferably 1-2 days delivery or offline?

Also is it worth paying the extra for ISO 400 rather than 200?

Also can I still take a roll of film into boots or somewhere or do I need to go somewhere special? What sort of price for developing them?

That website is perfect as well

Ive just got hold of an old camera I found in our house (a Zenit TTL) and id really like to get to grips with using it. Im a complete novice, so does anyone have a good guide for a newbie starting out in terms of all these things like exposure, f number etc?

What good things are going on in London this week? Especially outdoorsy stuff with all the sun?

Im just about to receive an iPhone 4 I bought off ebay, but its locked to O2. I could go and find somewhere with an O2 sim and borrow the sim to get it unlocked but this is going to be quite difficult, as ill have to borrow the sim for 3+ days. Is there a way I can unlock the phone without having a sim from O2, or taking 3+ days? If I do have to borrow a friends, do I have to leave it in the phone for the 3 days?

just bought this el cheapo to replace my lost everday casio

green canvas strap or keep as is?


What model is this?

http://www.phones4u.co.uk/

I didn't realise phones4u did second hand

Hi all

I'm looking to buy an iphone 4 on any network, any sellers?

I took a bit of a hit to a pothole with my rear wheel, which has buckled slightly around the outer flange of the rim. Id like to remedy this, so what items do I need to replace? Ideally I want to spend as little as possible.

I'm looking to sell my Specialized Allez Elite, 2010 model size 56cm.

I bought this bike off this very forum a few months ago and having been using it to commute to work and back since then. Now I'm heading back to Uni I no longer need it, so instead of letting it sit in the garage I want to see if it can go to a home which will use it more!

The bike has been well looked after, being degreased/greased and cleaned every few weeks. It has also always been stored indoors (garage at home, underground car park at work).

It has had the following upgrades:

Shimano RS10 front wheel £70
DTSwiss RR585 rear wheel on a shimano 105 free wheel hub. Hand built by Piotr at The London Bicycle Workshop £160
KMC chain £30
Deda bar tape £15
PRO LT seat post £25
Shimano Ultegra cassette (23-12) £45
Aztec Brake pads £20
Conti Gatorskin Hardshell x2 £50

I also have some Shimano MD-520 that I can throw in to the sale.

I am looking to sell all of this for £530 ONO.

I am located in South London and don't mind delivering the bike within a reasonable distance. I will also be in Bristol in the next few weeks and can deliver to anyone nearby.

Pictures:

Ive got Adidas Micoach, and you can set it to give announcements every x miles or minutes, so maybe set it to every 1 minute?

Quite new to road bikes, im considering getting some new wheels, especially as ive bumped the back one a bit on a pretty large pothole incident. What things do I need to look for when buying rims?

Ill dibs the frame depending on location, pm incoming

Ok, what about this?

mystr = mystr & "<a href="http://www.ncp.co.uk/find-a-car-park.htm?t=link&q=""

It seems to be having issues with the "" inside another ""

How can I get Visual Basic to enter:

Tube: Bayswater

Into a cell? I think its having problems with the characters, ive used " " on each side but its still giving an error.

Sorry to drag up an old thread but I didnt want to start a new one, where can you get wheels trued for £5 a wheel? Places I find seem to be charging £18-£20!

edit: sorted

[code]
Sub OperatorProp()

For i = 3 To 500

For j = 3 To 1727
    If Cells(j, "C") = Cells(i, "H") Then
     myStr = myStr & Cells(j, "B") & ", "
     End If

Next j
Range("I" & i).Value = myStr
myStr = ""
Next i

End Sub
[/code]

But is there a way to get the code to keep going until the end of the list without entering in the first and last value of the for loop?

Also, ive got a list of individual names from a larger set of data, how can I get Excel to produce lists of all data from the larger data set grouped under the individual names?

I basically want to do a VLOOKUP that returns multiple values relating to it

Alright im fairly new to VB, ive got the code changed to report column title, but can I get it to repeat untill the last cell, rather than enter the i min/max values?

This will be quite cumbersome to achieve in Excel, as you will need to explicitly check each cell in turn and append its location to a string. However, it's pretty straightforward with a few lines of VBA.

This (pretty poor) code makes a list in column A of each blank cell (by column number) in the row (from col B to col U) for rows 1-28. Should be pretty easy to modify

[code]

Sub thingy()

For i = 1 To 28
myStr = ""
For Each c In Range("B" & i & ":U" & i)

If c = "" Then myStr = myStr & ", " & c.Column

Next
Range("A" & i).Value = myStr
Next i

End Sub
[/code]

Cheers, I think this is exactly what I want.

Ive got some rows of data, most of which have information in. For each row I want to create a list of all the cells that are blank (ie their column header). I have managed to find the position of the first blank cell using [FONT=Arial][SIZE=2]=MATCH(TRUE,INDEX(V3:CA3="",0),0) but not sure how to make this find each other cell after that and make a list of it.
[/SIZE][/FONT]

Ok, cheers for the help.

Had a bit of an experience with a pothole this morning. The top of the edge of the rims are now pushed outwards slightly, like somethings been pushed between them and forced them outwards, is this easy to fix?

When I pull away from lights (just start cycling) theres a creaking sound, seems to be coming from the front fork, but I cant replicate it without riding it. Any ideas?