Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro error : Application-defined or object-defined error Joe Excel Discussion (Misc queries) 3 January 27th 06 02:32 PM
Error 1004 Application Defined or Object Defined Error Garry[_6_] Excel Programming 2 October 1st 04 10:33 AM
Macro Run-time Error 1004 Application Defined or Object Defined Error Anddmx Excel Programming 6 June 9th 04 03:40 PM
Runtime Error 1004 -- Application Defined or Object Defined Error John[_51_] Excel Programming 3 September 4th 03 04:28 PM


All times are GMT +1. The time now is 06:23 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"