How to append a row to an excel sheet using VBA program

Question

Hi,

In my programming i want to do some validations and need to update the result to output excel file.
But i was not bale to track the last row which is empty so that i can append my data.
could you plese update me how i can track the last empty row in the Excel which is a continuation row for the previously updated row?

thanks
medas

Answer 1

This forum is for VB.Net not VBA try here http://social.msdn.microsoft.com/Forums/en-US/vblanguage/thread/717e3fc3-8840-446d-8b7a-55a4052f48d6

---

coding for fun Be a good forum member mark posts that contain the answers to your questions or those that are helpful
Please format the code in your posts with the button . Makes it easier to read .

Answer 2

If you're doing this in Excel then follow the link posted by bdbodger. If you're using Visual Basic .NET then see the following forum post:

http://www.vbcity.com/forums/topic.asp?tid=4101

---

Paul ~~~~ Microsoft MVP (Visual Basic)

Answer 3

Yea, BD!!!
Renee