krishnak
03-21-2007, 12:06 PM
Hi All,
I have two workbooks open (Book1 visible and the Book2 minimized). For all the names in a specific range of Book1, I want to find the matches for another specific range in Book2. Both the ranges are in one column each.
I selected the start cell of the range of Book1 and then applied the code
Set rangeOne = Workbooks("Book1").Range(ActiveCell, ActiveCell.End(xlDown)). Now I want to shift the ActiveCell by code to the starting cell of the Book2 (which is still minmized). The starting cell of the Book2 is Range("D2"). When I apply the code Workbooks("Book2").Range("D2").Activate, I am getting an error.
I want to make that cell as the active cell and set the rangeTwo by a similar formula.
How can I do it?
Thanks for all the help I can get.
- Krishna
I have two workbooks open (Book1 visible and the Book2 minimized). For all the names in a specific range of Book1, I want to find the matches for another specific range in Book2. Both the ranges are in one column each.
I selected the start cell of the range of Book1 and then applied the code
Set rangeOne = Workbooks("Book1").Range(ActiveCell, ActiveCell.End(xlDown)). Now I want to shift the ActiveCell by code to the starting cell of the Book2 (which is still minmized). The starting cell of the Book2 is Range("D2"). When I apply the code Workbooks("Book2").Range("D2").Activate, I am getting an error.
I want to make that cell as the active cell and set the rangeTwo by a similar formula.
How can I do it?
Thanks for all the help I can get.
- Krishna