I have a stupid question

[BoredBloke]

FWIW it seemed to work ok when I tried it

=ValidPostCode(B3)

If you wanted to use it in your VBA rated that having a User defined Function on the worksheet you'd have to loop through the postcodes and throw each one to your function.


for i = 2 to lLR
cells(i,15) = ValidPostCode(cells(i,14))
Next i

[TheFaQQer]

FWIW it seemed to work ok when I tried it

It was a bug in Lisa's conditional formatting

I tried to send her your way, though, but to no avail

[LisaContractorUmbrella]

It was a bug in Lisa's conditional formatting

I tried to send her your way, though, but to no avail

It was yes. I had a bug

All sorted now though

[LisaContractorUmbrella]

It was a bug in Lisa's conditional formatting

I tried to send her your way, though, but to no avail

That hurts

[TheFaQQer]

That hurts

Oops I only meant that BoredBloke is a better VBA programmer than I am. Mainly because I'm not a VBA programmer but can blag a few things here and there

[LisaContractorUmbrella]

Oops I only meant that BoredBloke is a better VBA programmer than I am. Mainly because I'm not a VBA programmer but can blag a few things here and there

Well you're blagging was very useful

[mudskipper]

Oops I only meant that BoredBloke is a better VBA programmer than I am. Mainly because I'm not a VBA programmer but can blag a few things here and there

The hallmark of a true contractor.

Don't forget to invoice.

[Pondlife]

Oops I only meant that BoredBloke is a better VBA programmer than I am. Mainly because I'm not a VBA programmer but can blag a few things here and there

You've not read Suity's new rules, have you.