I am sorry but I am very new to this. How would I use this? Could I fill in
that last row with text to indicate the task completed?

"Bob Phillips" wrote:

This will get you the last row

Set rng = ActiveSheet.UsedRange
iLastRow = rng(rng.Count).Row


--

HTH

RP
(remove nothere from the email address if mailing direct)


"J_Garcia" wrote in message
...
I am writing a script in vbscript where I am querying multiple machines
and
moving that data into an excel spreadsheet. So the idea is that computer1
info is display in A1, B1, C1, etc. and computer2 is displayed in
A2,B2,C3,etc. Computer1 might need to display data in A1,A2, A3, B1, C1
so
when computer2 starts to display data it will start at A4 but then proceed
at
B2, C3, etc. What I want is for computer2 to display data at A4 for
example
and continue at B4, C4, etc. So I am trying to figure out how to
determine
the last cell used so that I may start the next display in a new row. I
hope
this makes sense, any help is much appreciated.