Still trying to figure out Excel and would appreciate a little help.

I need to make the current ROW be 1 row below the last row with data. If am using the following code:

ActiveSheet.Range("A1").End(xlUDown).Offset(1).Select

That code works in one SUB for a sheet my FORM refers to and fails in a SUB in the same FORM programming which is referring to a different sheet. I get the following error message only when trying the second SB referred to here.:

Application-Defined or Object-Defined Error

Needless to say I have beat my keyboard crazy before sending this message