If I know the data, I can usually pick out a column that is always filled if
that row is used.
Then I use this kind of code:
Dim NextRow as long
with worksheets("sheet1")
NextRow = .cells(.rows.count,"Z").end(xlup).row + 1
.cells(nextrow,1).value = "This would be in column A"
.cells(nextrow,2).value = "This would be in column B"
.cells(nextrow,3).value = "This would be in column C"
End With
Change Z to the column you can pick out.
Nils Titley wrote:
Dave,
Yea, you probably been developing VB application for a long time. I am just
developing some thing for a friend and I am learning some thing but I am lost.
I have another question..... can you give me an example of how I move to the
last row. I know how to get the last row value but I don't know how to make
that the starting point where I want to write the new set of data in the
workbook.
I have got the code to the point that I can read, I believe, multiple files
and it is process the data correctly. I believe what is happening now is
that when I write to the result workbook the data is over writing what I have.
I would appreciate your help.
Simple example.
Thanks
"Dave Peterson" wrote:
I always have that turned on, so I don't need to turn it on in code <vbg.
Nils Titley wrote:
Dave,
I like it but you also have to have
Application.DisplayStatusBar = True
Thanks
"Dave Peterson" wrote:
You could use a userform.
But even simpler is to use the statusbar--Where you see Ready, Edit, Point in
the bottom left corner.
application.statusbar = now & " Processing: " & somevariablenamehere
at the end of your code, you can reset the statusbar with:
Application.statusbar = false
Nils Titley wrote:
I am going to be processing some large files and I would like to dispaly what
file I am process but I don't want the user to have to click on a button. I
would like the box to display all the time. Is that possible to do? Where
do I start?
Thanks
--
Dave Peterson
--
Dave Peterson
--
Dave Peterson