Emoncada
03-19-2013, 09:50 AM
I am trying to make the following happen.
I have the user select a range then click a button.
That copies the selection and pastes it in another workbook.
What I need to do is then go back to where the user made the initial selection and to the left of the selection copy a cell value (all cells to the left of the selection should be same value) after copying that cell go back to 2nd workbook and paste in "F2".
I tried using SendKeys {Left}, but it doesn't seem to work, it keeps copying initial top cell.
Any Ideas?
I have the user select a range then click a button.
That copies the selection and pastes it in another workbook.
What I need to do is then go back to where the user made the initial selection and to the left of the selection copy a cell value (all cells to the left of the selection should be same value) after copying that cell go back to 2nd workbook and paste in "F2".
I tried using SendKeys {Left}, but it doesn't seem to work, it keeps copying initial top cell.
Any Ideas?