Actually, Sheets("Sheet1") is the sheet you are cutting to. A1 is the
destination.

The activesheeet, row with the active cell is the row you are cutting from
in the code Don provided.
rw = 10
activecell.entirerow.cut _
sheets("sheet1").range("a1")(rw)

or

rw = 10
activecell.entirerow.cut _
sheets("sheet1").range("a1").offset(rw-1,1)

would cut to row 10 on sheet1.

--
Regards,
Tom Ogilvy



dave wrote in message
...
Thanks for the quick response, but...

I know that I have to change "sheet1" to the name of the
sheet I'm cutting from but what does the range("a1")
select? I obviously don't always want row 1 so how do I
make that a variable reference?
dave
-----Original Message-----
see if this helps

activecell.entirerow.cut _
sheets("sheet1").range("a1")

"dave" wrote in message
...
I've been a programmer for many years. I can do the
programming if I can figure out how to get at the data.
That's my problem with using VBA with Excel (or Word,
etc.) How do I find out how to access a cell, group of
cells, range, worksheet, etc. using VBA.

For example, I have a worksheet that has rows of data.
I
would like to search a column for a particular value
and
if it is present, delete the data and row from the
current worksheet and paste it into another sheet. I
can
figure out how to search for the data by recording a
macro when I do it manually. But when I then select the
row to so I can do a Ctrl-X to "move" the data, the
recorded macro does a .Select on that specific row. I
need to be able to have the selected row number put
into
a variable that I can use to "cut" the data then when I
go to the target sheet I need to have the target row
incremented. Then I want to go back to the source
sheet,
delete the row and repeat process until the search is
no
longer successful.
How do I do those kind of things? I'm not real familiar
with the data setup that allows me access to the
features
I need.

Thanks for any and all help,

dave


.