| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Getting Last Non-Blank Row Number With VBA
Hi Everyone
In Excel I can place the following in a cell to get the last non blank row number in column A. This works great and it's super quick. =ROW(OFFSET(A1,COUNTA(A:A)-1,0)) To do the same with VBA code seems very complex. Can you please show me some VBA code that will give me the last non-blank row number for a given column? Andy |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| row number of last non-blank cell | Excel Worksheet Functions | |||
| Maximum Number of Blank Cells between Non Blank Cells in a Range | Excel Worksheet Functions | |||
| How to find the first non-blank number in a row? | Excel Worksheet Functions | |||
| BLANK SPACE TO A NUMBER | Excel Worksheet Functions | |||
| First non blank number in a row | Excel Discussion (Misc queries) | |||
Threaded Mode
