How do you define "next available row" ??
Is your spreadsheet filled with no blank rows
and you're looking for the last row?
or does your sheet have blank rows in the middle of data?
If the first is true (no blank rows)
There is a couple ways to do it.
the way I like is to use a Worksheet Function:
RowCnt = Application.WorkSheetFunction.Counta(Range("A1:A65000"))
this gives the total number of non-blank cells in column "A"
(assuming column "A" ALWAYS has data!)
the next available would be RowCnt + 1
hth,
Paul
________________________________
From: iwasinnihon <iwasinni...@gmail.com>
To: MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com>
Sent: Wednesday, March 4, 2009 10:38:51 AM
Subject: $$Excel-Macros$$ Find next available row
I am writing a macro and would like to have it find the next available
row on a sheet, enter the date, do a vlookup, and enter a running
sum. I can do everything except find the next available row. How
would I do this?
--~--~---------~--~----~------------~-------~--~----~
-------------------------------------------------------------------------------------
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-------------------------------------------------------------------------------------
-~----------~----~----~----~------~----~------~--~---
