What is wrong with this range description

**petca059** · 07-23-2010, 04:16 AM

Please Login or Register  to view this content.

object or aplication defined error

**Andrew-R** · 07-23-2010, 04:29 AM

If you just print the results of the UBound(allvalues,2) and allvalues(3,0) are they returning the expected results?

**romperstomper** · 07-23-2010, 04:33 AM

You need to specify the sheet for the Cells calls too if they are not on the activesheet (or the sheet containing the code, if applicable):

Please Login or Register  to view this content.

**petca059** · 07-23-2010, 04:40 AM

Thanks a lot! drove me nuts..

Re: What is wrong with this range description