test please delete

[SimonMac]

Ignore the below

Sub FindDate()

For Each cell In ActiveSheet.Range("c2:zz3")
    If cell.Value = [Today()] Then
    cell.Select
    End If
Next

End Sub

Bit of VB I need for a macro on an excel spreadsheet I use, but can't email it to myself

[Dallas]

So when are we doing lunch again? Next week?

Ola, cant do Tuesday, otherwise all-clear, whens good for you?

[eek]

Found your passport yet?

Nope. New one is being ordered this weekend...

[NickFitz]

You know you're getting old when you take pain killers for one thing and notice all the other things that stop aching

Too right

[NickFitz]

Ignore the below

Sub FindDate()

For Each cell In ActiveSheet.Range("c2:zz3")
    If cell.Value = [Today()] Then
    cell.Select
    End If
Next

End Sub

Bit of VB I need for a macro on an excel spreadsheet I use, but can't email it to myself

Should have posted it in Technical

[SimonMac]

Should have posted it in Technical

People might actually see it in there!

[eek]

Nope. New one is being ordered this weekend...

Mrs Eek has finished tidying up again. No god of irony in sight....

[mudskipper]

Ignore the below

Sub FindDate()

For Each cell In ActiveSheet.Range("c2:zz3")
    If cell.Value = [Today()] Then
    cell.Select
    End If
Next

End Sub

Bit of VB I need for a macro on an excel spreadsheet I use, but can't email it to myself

May I suggest that, if you wish to stop when 'Today' is reached, you consider an 'Exit For'

[SimonMac]

May I suggest that, if you wish to stop when 'Today' is reached, you consider an 'Exit For'

You can suggest what ever you like sweeite, doesn't mean I will understand it

This was created the same way every other bit of "coding" I have ever done, by reverse engineering something else so it does what I need it to do!

[eek]

You can suggest what ever you like sweeite, doesn't mean I will understand it

This was created the same way every other bit of "coding" I have ever done, by reverse engineering something else so it does what I need it to do!

Well it does it, but not as efficiently as it could do it.....