Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Locating end of coloumn to add more data
I'm transferring data from different sheets to one summary sheet.
I want to add at the bottom of the list. How can I find the range position (it would be row in my case) so I can start my counter to that value ? tia |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Locating end of coloumn to add more data
Try something like the following:
Dim LastRow As Long LastRow = ActiveSheet.Cells(Rows.Count, "A").End(xlUp).Row + 1 Debug.Print LastRow Change the "A" to whatever column is relevant. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Junkyard Engineer" wrote in message ... I'm transferring data from different sheets to one summary sheet. I want to add at the bottom of the list. How can I find the range position (it would be row in my case) so I can start my counter to that value ? tia |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sort one coloumn according to another coloumn on another worksheet | Excel Worksheet Functions | |||
Locating and selecting Data from Worksheet | Excel Discussion (Misc queries) | |||
How to search data in one coloumn | Excel Worksheet Functions | |||
Merging data looking up (Account) numbers in a coloumn | Excel Worksheet Functions | |||
locating given dates from each year in data set | Excel Programming |