ermccarthy
Board Regular
- Joined
- Feb 15, 2002
- Messages
- 224
I have written a small macro that I want it to look the value of the Active cell from one workbook on a second workbook, but I am have no luck......This is what I have, if it leave my value just to say Active cell, when you switch windows, the value changes. But I can't seem to get it to work using the following command either. What am I doing wrong??
exch = Windows("Rates").ActiveCell.Value
Windows("GLEIS.DBF").Activate
Range("A2").Select
Do Until ActiveCell = (exch)
ActiveCell.Offset(1, 0).Select
Loop
exch = Windows("Rates").ActiveCell.Value
Windows("GLEIS.DBF").Activate
Range("A2").Select
Do Until ActiveCell = (exch)
ActiveCell.Offset(1, 0).Select
Loop