LinkBack URL
About LinkBacks
This is what I have come up with so far.
But as soon as it opens the file stated in cell (1,2), it fails to go to (2,2)
Please Login or Register to view this content.
This is what I have come up with so far.
But as soon as it opens the file stated in cell (1,2), it fails to go to (2,2)
Please Login or Register to view this content.
You are not doing anything to the workbook when you are opening it.
Loop Until Cells(r, 2) = "" .....is now in the active worksheet because you never closed the 1st workbook after you opened it.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
,
Bookmarks