VBA How can I make this work for the active sheet Excel 2003

[dee101]

This works
MsgBox Sheet1.Range("L1")

But I want to get what is in L1 in the active sheet, something like below, but this does not work, how would this be done

sn = ActiveSheet.CodeName
MsgBox sn.Range("L1")

Thanks

 

[Phuoc]

Try this

MsgBox ActiveSheet.Range("L1")

 

[Peter_SSs]

.. or just this

MsgBox Range("L1")