Application-defined or object-defined error

[siobeh]

Hi,

I'm getting an error 'Application-defined or object-defined error' for the below code.
When debugging, it is goes on the highlighted line, I've used the below code on my other projects and it run okay but I'm now encountering the error now.

Please Login or Register  to view this content.

[Kaper]

and what is n while macro stops?

Check it with Locals window or add

Please Login or Register  to view this content.

before

Please Login or Register  to view this content.

I suspect it could be 0 and then obviously the line above generates an error.

[judgeh59]

I'm not seeing a highlighted line...????

nevermind....I was looking for a little more highlighting.....<insert sheepish grin>

[AB33]

Siobeh,
Since this is my code, I will adjust it if you could attach your book.

[AB33]

Use this lines

Please Login or Register  to view this content.

[siobeh]

Hi AB33,

I've pattern the sequence of the macro from my other project on my current project. It's now resolved.

**Off-topic**
Question:

I have two Columns ( A & B) , and I need to mimic the value of Column A to B. I just want to set the value.
The logic is seems like the below code, but i want the rows.

Please Login or Register  to view this content.

Is this correct?

Please Login or Register  to view this content.

[AB33]

Please Login or Register  to view this content.