VBA code works in one SUB and fails in a different SUB

**jcaskey** · 06-17-2013, 11:12 AM

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

**Norie** · 06-17-2013, 11:17 AM

It's probably because it's a different sheet not a different sub.

Also using xlDown can cause problems, use xlUp instead.

Please Login or Register  to view this content.

**jcaskey** · 06-17-2013, 11:28 AM

A big thanks for the quick help and excellent fix.

I have been on other forms before that were not related to Excel. I have to admin that thios forum is the most informative and useful one I have seen. The folks who hang around here just seem to ne great folks.

I am interest in what you meant about 'xlDown' giving problems.

**Norie** · 06-17-2013, 11:33 AM

If you use xlDown you could end up on the very last row in the worksheet.

When you try to move down from that row you'll get the error you describe as you are trying to move off the worksheet.