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
|