Re: Offset error in one, but not another workbook
Thank you for your continued work with me on this.
I am uncertain of the differences between xlDown and xlUp and could not find much that makes me any brighter on this either. Anything that makes me a grain smarter is appreciated.
I suppose it would help to clarify what i am now looking to achive in order to not waste your time and to allow you to help me further.
The spreadsheet i am working with (there are actually two, which have the same general set-up, for different data though) has data in columns A:P and the other A:M. Although most of the rows will have data in all columns, there are rows where any given number of cells, in any combination, may be blank.
The first request was to force the user to use that last empty row. Now the request changed to remind the user to use the last row and not just any empty row.
I would like to find the next available empty row and if the user is attempting to enter data in any row below that, have a msgbox telling the user that s/he should enter date in the last empty row, not the current selected one.
if current active row <> last empty row then msgbox