activecell.offset

[steelsoul]

Hello
In the following code i get a runtime error "Application-defined or object-defined error"
I know that a 1004 error is hard to find. Let me show you what i realize so far.
Here is the code

Please Login or Register  to view this content.

The error occurs at the line I marked with ***
After much pain I found that if I change the "ActiveCell.Offset(1, 1), ActiveCell.Offset(jobs, 31)" part to any other range like " "b4:af13" " (like it should amount to at the first loop instance) it runs perfectly.

Can you please tell me how to fix it so I can run it with the activecell? (you might have noticed I am changing the active cell at each iteration of the loop)

Thank You

[Andy Pope]

Try making the cwb active in order to use the activecell reference.

Please Login or Register  to view this content.

[steelsoul]

Thank you.. so simple
solved