Problem finding the value of the column of the active cell on the cuent sheet

[Lconner]

My code is:

Please Login or Register  to view this content.

The problem I am experiencing is when the program reaches the while loop. The conditions And (ActiveCell.Column) < e and (ActiveCell.Column) >= e Are mis-triggering it is as if the conditions is not evaluated at all or (ActiveCell.Column) >= e is all ways true which it is not).

Originally I wrote the code from the while loop down. The code as shown worked. After I was requested that the code/ability include the capability to copy an entire sheet from another workbook to the workbook where the macro is hosted, the top part of the code was added.

The problem I think arises since the code is set to run on the 2nd sheet the 17th column, Q, is not 17 as assumed. Is there a way to:

1 to alter the syntax of (ActiveCell.Column) < e So it knows I am trying to refer to 17th column on the second/last/active sheet?

2 Or make it so the value of e always refers to 17th column on the current sheet?

thanks
lconner

[xladept]

Change the "and" to "or" as nothing could satisfy both conditions

[Lconner]

Sorry that dose not make since to me. the second condition test for the value of the active cell while the third condition is to test for the postilion of the active cell. how are they exclusive each other? and that still dose not explain why the code worked before the code to add the second sheet was added. What I need is the syntax to test the position of the active cell in a workbook with mutable worksheets. also sheets are to be consistently added the syntax needs to account for this.

[xladept]

Well - I'm confused - You're activating "A1" so that's always the activecell???

[Lconner]

I am not always activating the A cell, just testing it value. you can test a value of a cell with out that cell being, the active one. the active cell dose change as the loop repeats its self.

[Lconner]

does any one have an answer?

[JOHN H. DAVIS]

Maybe:

Try removing the parentheses:

Please Login or Register  to view this content.

[Lconner]

Sorry that dose not work. Any other ideas?

[Lconner]

Could some at least point me to a good source on this. I tried searching for it and nothing come up.