I was implying you change your original code to, instead of inserting
rows, simply write the info to the blank rows already provided. Your
post is a little vague. What you mention can be done but all I can
offer is psuedo code based on your desricption. From what I gathered
from your post is that the unix numbers are inserted into a spreadsheet
that already has blank rows. You could use your macro to write them to
the blank rows. The code would be something like this

Workbooks("Final Rpt.xls").Worksheets("Sheet").Range("b1").value = _
Workbooks("Unixrpt.xls").Worksheets("Sheet1").rang e("a1").value

This would give the cell B1 the value of Sheet1 of the Final Report the
value of cell A! on Sheet1 of the Unix Report. If you could give some
more details I could probably help more.

Hinojosa via OfficeKB.com wrote:
Because in order to get the info I have to run a report from a unix based
enviroment and the report downloads into an excel workbook from there I
created a marco to pull the info that i need and send it into the final excel
report and to write the info in a blank row would take forever there are over
500 some people each one with different numbers.

bobbo wrote:
Instead of Inserting Rows why not just write your information to one of
the blank rows?

I've written a macro that is basically merging two documents sorta. Anyways
what I need is a command or something that will do the following:
[quoted text clipped - 12 lines]
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200610/1

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200610/1