i want to have a macro that will copy a selection of rows and insert them in
a variable location in my spreadsheet..... ex: say i am at row 100 and want
to copy data from rows from sheet 2 say rows 25 - 150 and them insert them
at row 100 (this time, may be row 200 next time). i can get my macro to go
find the data copy it and return to row 100 every time. what i am having
trouble with is how to make it retrun to where it started from ... be it row
100 or 200 or 250 or where ever.

any help you can offer is greatly appreciated

tia

wc

Why not just use a variable to hold the starting row so you can come back
there?
StartRow=activecell.row
Maybe I don't understand the problem.
James
"wile coyote" wrote in message
...
i want to have a macro that will copy a selection of rows and insert them
in a variable location in my spreadsheet..... ex: say i am at row 100 and
want to copy data from rows from sheet 2 say rows 25 - 150 and them insert
them at row 100 (this time, may be row 200 next time). i can get my macro
to go find the data copy it and return to row 100 every time. what i am
having trouble with is how to make it retrun to where it started from ...
be it row 100 or 200 or 250 or where ever.

any help you can offer is greatly appreciated

tia

wc

I am a obviously a newbie to macro, vba and customizing

thank you very much for your "easy fix"

my macro now works perfectly

i appreciate you taking time to pass on your knowledge even to us
annoying newbies

best wishes

wc


"Zone" wrote in
:

Why not just use a variable to hold the starting row so you can come
back there?
StartRow=activecell.row
Maybe I don't understand the problem.
James
"wile coyote" wrote in message
...
i want to have a macro that will copy a selection of rows and insert
them in a variable location in my spreadsheet..... ex: say i am at row
100 and want to copy data from rows from sheet 2 say rows 25 - 150 and
them insert them at row 100 (this time, may be row 200 next time). i
can get my macro to go find the data copy it and return to row 100
every time. what i am having trouble with is how to make it retrun to
where it started from ... be it row 100 or 200 or 250 or where ever.

any help you can offer is greatly appreciated

tia

wc

Glad to help. We all start as newbies! James
"nowhereman" wrote in message
. 96.26...
I am a obviously a newbie to macro, vba and customizing

thank you very much for your "easy fix"

my macro now works perfectly

i appreciate you taking time to pass on your knowledge even to us
annoying newbies

best wishes

wc


"Zone" wrote in
:

Why not just use a variable to hold the starting row so you can come
back there?
StartRow=activecell.row
Maybe I don't understand the problem.
James
"wile coyote" wrote in message
...
i want to have a macro that will copy a selection of rows and insert
them in a variable location in my spreadsheet..... ex: say i am at row
100 and want to copy data from rows from sheet 2 say rows 25 - 150 and
them insert them at row 100 (this time, may be row 200 next time). i
can get my macro to go find the data copy it and return to row 100
every time. what i am having trouble with is how to make it retrun to
where it started from ... be it row 100 or 200 or 250 or where ever.

any help you can offer is greatly appreciated

tia

wc