Can you suggest a way to interupt my code whilst the user selects a row. ie. if I wanted to move the contents of one row to another I would want to say:
"select source row" (and want the user to click on any cell in that row) I could then put the rownumber in a variable with
then "Select destination row" (same, wait for the user to select a cell in the row) then either continue with code or click OK to continue. I have tried a messagebox but this wont allow me to select a row without first clicking OK
Bookmarks