Return Cell Address with VBA

[another rachel]

Hello
I am trying to see if the macro I have started to write is working.
However, forget how to use the msgbax command....

I have written the following and would like the macro to return the cell reference of the first empty cell.

I know this is easy as I have done it before but can't remember how

Any assistance, as akways, is much appreciated
Regads
Rachel

Dim lastnumber As Range
Dim firstemptycell As Range

Set lastnumber = Range("A65536").End(xlUp)
Set firstemptycell = lastnumber.Offset(rowoffset:=1, columnoffset:=0)

 

[tusharm]

Re: using last cell refrence

A) Talk to your boss. Get her/him to get the IT Nazis to give you the configuration you need to be productive.
B) If you have web access, msdn.microsoft.com has most (all?) of the MS help files in one form or another.

Thank you!

In a very annoying move, the helpfile in VBA Excel has been "switched off" at my place of work. :x
{snip}