Jealousy

[cornflakegirl]

I was wondering where the :vomit: emoticon was myself!

 

[Oorang]

What pants?

Auughhh!!!!! Suprise and Terror! Teh horrorz! Teh horrorz!

 

[RoryA]

I was wondering where the :vomit: emoticon was myself!

There's a whole bunch of useful smilies missing from this place!

 

[RoryA]

Damñed near ...

You've been spending too much time in the other languages boards...

 

[Oorang]

There's a whole bunch of useful smilies missing from this place!

I think there should sum it up pretty well:

 

[DonkeyOte]

What pants?

Still wearing that soiled nappy from the other day are you Rory ?

(seriously -- don't answer that)

 

[cornflakegirl]

Just when you thought the tone couldn't get any lower...

 

[Colin Legg]

Wasn't only the tone that had gone too low!

 

[BAlGaInTl]

The lastrow discussion has me intrigued.

I don't put myself in the same league as most here, but it seems something is wrong with my sledge hammer as it often starts with the macro recorder and then gets me something like this:

Sub Macro1()
Dim lRow
Dim ws As Worksheet
    Set ws = Sheets("Sheet2")
    lRow = ws.Cells.SpecialCells(xlLastCell).Row
    MsgBox (lRow)
End Sub

I never thought of trying to find a new way to do it really without starting in a particular column.

 

[BAlGaInTl]

Also, if I'm only worried about the sheet I'm currently working on, I can simplify it to:

Sub Macro1()
Dim lRow
    lRow = Cells.SpecialCells(xlLastCell).Row
    MsgBox (lRow)
End Sub

hmmmmm....

I learned something new today. Yeah!