Hi,
I'm trying to copy over a set of cells based on the content of cell. It not working for me and the macro stops at the If statement. Any thoughts? code below.
Thanks in advance,
+HZ
Please Login or Register to view this content.
Hi,
I'm trying to copy over a set of cells based on the content of cell. It not working for me and the macro stops at the If statement. Any thoughts? code below.
Thanks in advance,
+HZ
Please Login or Register to view this content.
Last edited by hani9041; 03-12-2012 at 08:34 AM. Reason: Issue was resolved
The property value can't be applied to the type cells. You need to do it with range instead. Try:
I hope that helps.Please Login or Register to view this content.
I had tried it with range but it didn't work either. It still breaks on the If statement.
For some reason the following statement is giving me problems:
Please Login or Register to view this content.
Okay I think I got it. You can't just pass in cells, you also need to pass in the address to the cell here is my latest code.
But I can't get it to past to the new sheet.Please Login or Register to view this content.
+hz
Last edited by hani9041; 03-01-2012 at 03:06 PM. Reason: removing comments from code
I'm making progress on this but I'm not sure if I'm copying and pasting correctly. Please take a look and help.
Please Login or Register to view this content.
Last edited by hani9041; 03-01-2012 at 03:29 PM. Reason: Added code
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks