I am need a macro to go up 1 row
 

I have to copy data from one row to a variable number of rows below; I have a
macro that selects the data and hi-lites the rows below including the next
data row.
I need to either select 1 less row or come up 1 row. Can someone suggest
how I can accomplish this task?

As always, post your code for comments and suggestions.

--
Don Guillett
SalesAid Software

"David" wrote in message
...
I have to copy data from one row to a variable number of rows below; I
have a
macro that selects the data and hi-lites the rows below including the next
data row.
I need to either select 1 less row or come up 1 row. Can someone suggest
how I can accomplish this task?