Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
The best sub for last row / last column / last cell?
I see so many different ways to get the last row/ last column/ last cell ona
sheet. Since I need to use these functions so often, I am wondering what is truly and definitively the best (most accurate, most efficient & quickest, in that order) way to determine last row and/or last column, and/or last cell. there are several ways on this thread alone: http://www.microsoft.com/office/comm...=en-us&m=1&p=1 What is the best way, and why? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Maddening Dilemma - Compare each cell within column a to each cell in column b and find unique matches | Excel Worksheet Functions | |||
Sum Cell Values of one column based on Another Cell Value in a different column | Excel Worksheet Functions | |||
Hiding column if cell in previous column is empty-revised | Excel Programming | |||
Loop through column headers to search from column name and get cell range | Excel Programming | |||
Format cell in column B based on value in the next cell (column c) | Excel Discussion (Misc queries) |