|Creates a cell reference as text, given specified row and column numbers.|
|=ADDRESS( row_num, col_num, [abs_num], [a10], [sheet] )|
|row_num||The row number to use in the cell address.|
|col_num||The column number to use in the cell address.|
|[abs_num]||The address type.|
|[a10]||The reference style.|
|[sheet]||The name of the worksheet to use.|
Skillshare’s usually $10 a month, but because you’re an OfficeTuts reader you can get your first month free by clicking here. That’s unlimited access to over 18,000 classes on Excel, VBA, and much more.