Horje
excel formula for last non-empty cell in a column Code Example
excel formula for last non-empty cell in a column 
'Excel formulas.

'Last filled cell in column A, confirm with Ctrl-Shift-Enter:
=INDEX(A:A,MAX((A:A>"")*(ROW(A:A))))


'Row number of last filled cell in column A, confirm with just Enter:
=INDEX(MAX((A:A>"")*(ROW(A:A))),1)
Source: academy.excelhero.com



Vb

Related
vba round number Code Example vba round number Code Example
vba reverse string Code Example vba reverse string Code Example
excel vba to lower case Code Example excel vba to lower case Code Example
if inputbox cancel vba Code Example if inputbox cancel vba Code Example
vba remove first 2 characters from string Code Example vba remove first 2 characters from string Code Example

Type:
 Code Example
Category:
 Coding
Sub Category:
 Code Example
Uploaded by:
 Admin
Views:
 7



 

Horje