Mega Code Archive

 

Categories / MSOfficeExcel 2007 Tutorial / Information Functions

 

=CELL(row, B6) returns the row number of the first cell in the range

Input the formula: =CELL("row", B6). Press Enter to get the result.