I am a recovering VB developer, so I know VBA. I am not super familiar with the Excel object model. I want to write a macro in a workbook. I have an unknown # of rows of data. I want to navigate to the first row that does not contain data. I then want to create a function in that cell =MAX(A2, Ax) where x is the last row of data. I then want to replicate that formula for each column until the first column without data is reached.

Does anyone have pointer to a referenced? Do I somehow iterate through the rows until I get an empty one? And likewise the columns?

A nudge would be useful. Thanks

S