macro - tracking cursor position in macro

[Avelino P. Arabit]

Hi,

Need help on macro, pls. see if what I'm thinking is
possible:

I have 2 sheets in my file, the first sheet is where I
input my data and I formatted sheet 2 for printing
purposes.

Let say I have these in sheet 1:

Data 1 Date 2 Data 3

aaaa aaaaaa aaaaaaaaaaaaaa
bbbb bbbbbb bbbbbbbbbbbbbb
cccc cccccc cccccccccccccc

Let say my cursor is on the first row of my data.

I created a macro, with a corresponding shortcut key, so
that the data on that row will be transferred to sheet 2
like:

Data 1 aaa
Date 2 aaaaaa
Date 3 aaaaaaaaaaaaaa

Now, I want to change the code (or maybe there is
something better) created by the macro so that when I
move the cursor to another row, say the next row, the
corresponding data will be the ones transferred. The
problem is I don't know which or what to change...

I'm using Excel 2000.

I hope somebody could enlighten me on this.

Thanks...


Avelino P. Arabit
Philippines

 

[A.W.J. Ales]

Avelino,

Maybe I'm misunderstanding your question, but if by replacing the cursor you
also mean replacing the actice cell (the cell you would be wordking on if
you enter a value, you can get the addres of the active cell by
Activecell.addres

--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *