Application or object defined error

**ref** · 02-07-2012, 08:32 AM

I get application or object defined error in the various forms shown below:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

What I'm trying to do is to select a range of rows from a previous selection. What is the correct form?

**OnErrorGoto0** · 02-07-2012, 08:36 AM

Try this

Please Login or Register  to view this content.

**ref** · 02-07-2012, 08:44 AM

Originally Posted by OnErrorGoto0

Try this

Please Login or Register  to view this content.

It didn't work.

Please Login or Register  to view this content.

didn't work as well.

**ref** · 02-07-2012, 08:46 AM

The whole statement is

Please Login or Register  to view this content.

The above works, not the below.

**OnErrorGoto0** · 02-07-2012, 08:55 AM

Your With... End With statements are not achieving anything. I assumed you had rows selected - perhaps you meant

Please Login or Register  to view this content.

**ref** · 02-07-2012, 09:03 AM

Originally Posted by OnErrorGoto0

Your With... End With statements are not achieving anything. I assumed you had rows selected - perhaps you meant

Please Login or Register  to view this content.

Worked, ty.

**OnErrorGoto0** · 02-07-2012, 09:08 AM

My pleasure.

Please do not forget to mark the thread solved.

Re: Application or object defined error