Am I right in thinking this is what your programme does (sorry, I haven't done much macro-writing, and it's all been with OpenOffice rather than Excel):
* Given variable "Target" which will be a cell in column "A"
* Search for a cell in worksheet 2, column H whose value is "CBSC01CA" followed by
the contents of cell A
* If you've found a cell which matches the above criteria, then copy cells D and I
in the row of the cell into the cells B and C in the row of the highlighted
Is this right? And the problem is that when you enter text, depending on how you finish editing the text (pressing enter/escape/an arrow key) the position of the highlighted cell is different when you call the function?
In this case, how does the sub get called? Is this done by another one of your subs?