Hello Leith Ross,
Thank you very much for your help...
I tried the change but the problem still seems to continue "Its giving me 'Run Time Error 1004: Application defined or Object defined error"...The code breaks when it reaches the line
' Set PartRngWorkbook1Reference1 = Worksheets("Refer").Range("A", Worksheets("Refer").Range("A65536").End(xlUp))'....
Hello ,
You did not specify a row for "A" . I have inserted "A1" into the code. Change the starting address if you need to.
Set PartRngWorkbook1Reference1 = Worksheets("Refer").Range("A1", Worksheets("Refer").Range("A65536").End(xlUp))'....
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks