I have a spreadsheet containing different groups of data, each of which vary in number of lines, separated by single blank lines. The number of groups also varies from month to month. I can find the last line of a particular group using 'SelectionEnd(xlDown).Select' with no problem but i don't know how to capture the row number of that last row. I need that to AutoFill a formula in the adjoining column. I plan on looping through this logic depending on the number of "groups' of lines I find. Any help will be appreciated.