joshua1990
04-19-2017, 04:47 AM
Hi Guys!
I am currently working through my VBA book and the Internet, but have not found an elegant approach to my problem.
I have a worksheet, which is edited by several macros when opening through the workbook_open event.
This means that a user opens the file and receives a finished structured document.
For this to work, however, the first column (A2: A) must contain numbers. Last line is oriented to column B ("Sheets (" tblOne "). Cells (.Rows.Count," B ") End (xlUp) .Row").
I now want to put a macro at the first position in the workbook_open event, which checks whether there are any numbers in A2: Lastrow anywhere. Otherwise the error (msgBox) message "***" should appear. The user should then have the option that the workbook_open event runs the remaining procedures, or the document is closed.
Best regards
Joshua
I am currently working through my VBA book and the Internet, but have not found an elegant approach to my problem.
I have a worksheet, which is edited by several macros when opening through the workbook_open event.
This means that a user opens the file and receives a finished structured document.
For this to work, however, the first column (A2: A) must contain numbers. Last line is oriented to column B ("Sheets (" tblOne "). Cells (.Rows.Count," B ") End (xlUp) .Row").
I now want to put a macro at the first position in the workbook_open event, which checks whether there are any numbers in A2: Lastrow anywhere. Otherwise the error (msgBox) message "***" should appear. The user should then have the option that the workbook_open event runs the remaining procedures, or the document is closed.
Best regards
Joshua