last row in excel ?
last row in excel ?
last row in excel ?
last row in excel ?
last row in excel ?
last row in excel ? last row in excel ? last row in excel ? last row in excel ? last row in excel ? last row in excel ? last row in excel ? last row in excel ?
last row in excel ? last row in excel ?
last row in excel ?
Go Back  Xtreme Visual Basic Talk > > > last row in excel ?


Reply
 
Thread Tools Display Modes
  #1  
Old 02-28-2005, 03:25 AM
Nick_1 Nick_1 is offline
Freshman
 
Join Date: Jan 2005
Posts: 44
Default last row in excel ?


Thanks all for the help Hopfuly my last problem is finding the last row in an excel sheet.the sheet is a long list of rejected claims four colums wide,
date-item-store-value.
I need to add to the end of this list with info from bound contols each time a button is clicked. I need to be able to find the last row used so i can change the cell address for the next entry.Thanks in advance
Reply With Quote
  #2  
Old 02-28-2005, 06:33 AM
italkid's Avatar
italkid italkid is offline
Down...

Retired Moderator
* Expert *
 
Join Date: Dec 2002
Location: Belgium.
Posts: 6,731
Default

There are multipe ways to know the last row, THIS is one of them...
Reply With Quote
  #3  
Old 03-01-2005, 01:22 AM
Nick_1 Nick_1 is offline
Freshman
 
Join Date: Jan 2005
Posts: 44
Default

Quote:
Originally Posted by italkid
There are multipe ways to know the last row, THIS is one of them...
Thanks for the link but I had already sorted it out. I try & try & try but get nowhere but as soon as i post a Question I figure it out. This is what i came up with
Code:
Dim Lrow As Integer Dim x As Integer Lrow = xlsheet.UsedRange.Rows.Count x = Lrow + 1 ' input data to sheet xlsheet.Cells(x, 1) = txtdate.Text xlsheet.Cells(x, 2) = txtstorenum.Text xlsheet.Cells(x, 3) = TXTCLAIMNUM.Text xlsheet.Cells(x, 4) = txtcode.Text xlsheet.Cells(x, 5) = total
All i needed was the row value as the colums are always the same hope this helps out others.Nick_1
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Forum Jump

Advertisement:





Free Publications
The ASP.NET 2.0 Anthology
101 Essential Tips, Tricks & Hacks - Free 156 Page Preview. Learn the most practical features and best approaches for ASP.NET.
subscribe
Programmers Heaven C# School Book -Free 338 Page eBook
The Programmers Heaven C# School book covers the .NET framework and the C# language.
subscribe
Build Your Own ASP.NET 3.5 Web Site Using C# & VB, 3rd Edition - Free 219 Page Preview!
This comprehensive step-by-step guide will help get your database-driven ASP.NET web site up and running in no time..
subscribe
last row in excel ?
last row in excel ?
last row in excel ? last row in excel ?
last row in excel ?
last row in excel ?
last row in excel ? last row in excel ? last row in excel ? last row in excel ? last row in excel ? last row in excel ? last row in excel ?
last row in excel ?
last row in excel ?
 
last row in excel ?
last row in excel ?
 
-->