View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson[_5_] Dave Peterson[_5_] is offline
external usenet poster
 
Posts: 1,758
Default error: ActiveCell.Offset(0, -1).Select = Application-defined orobject-defined error

Maybe not...

I didn't look at the rest of your code where you were changing selections.
Maybe your loop takes care of that.

(I didn't look close enough!)

"-[::::Shamran::::]-" wrote:

"Dave Peterson" wrote in message
...
Excel has 256 columns.

You're running a loop from 1 to 6000 that tries to move one column to the
left:
ActiveCell.Offset(0, -1).Select

it should blow up pretty early in the loop.


Jep .. quiet stupid ... ille try harder next time ! *GGG*

Thanks

Shamran


--

Dave Peterson