VBA Nested For Loop

**jbuckets** · 12-15-2012, 07:46 PM

Hi,

What am I doing wrong here? What I want is for any column with name "ColName" is for and values 0 or "FALSE" within that column be assigned to a variable and ultimately copied to another sheet. I keep getting a type mismatch on the 5th row down. Let me know if you guys have any ideas or can advise why I get this error. In the immediate window both i and Z are assigned what I would like them to be.

Thanks!!!

Please Login or Register  to view this content.

Let me know if you guys need anything from me. Thanks again!!!

Original Post

**shg** · 12-15-2012, 07:56 PM

Please take a few minutes to read the forum rules about cross-posting.

**jbuckets** · 12-15-2012, 07:58 PM

Had no dea the forums were related. It is a difficult question so why wouldn't io post it to multiple forums? I will keep this in mind i the future.

**jeffreybrown** · 12-15-2012, 08:01 PM

@jbuckets,

The forums are not related; however, they are members who visit this forum along with many others.

If you would like to continue with this thread, please reply with the request in post #2.

Read this to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site).