hi
use this 2 lines in top
Dim myloc As Range
Set myloc = ActiveCell
& use this line in bottom
myloc.Select
Cheers!!
On Mon, Sep 1, 2014 at 8:21 AM, AED wrote:
> I have the following code that copies a range and pastes it every 20
> seconds on the next line in Sheet2. Here is the probl
I have the following code that copies a range and pastes it every 20
seconds on the next line in Sheet2. Here is the problem, when it fires off
it jumps to Sheet2 performs the task and the pauses for 20 seconds and then
loops again. So if I am on Sheet1 is routes me to Sheet2 and leave me
there
