Assuming LastValue is a worksheet reference, you'd do that with code like:
Dim LastValue As Worksheet
then you need to tell VBA which worksheet LastValue refers to, using code like:
Set LastValue = Sheets("SomeWorksheetName")

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]