View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Claus Busch Claus Busch is offline
external usenet poster
 
Posts: 3,872
Default Exit when Cancel clicked.

Hi,

Am Mon, 6 Jun 2016 09:50:36 -0700 (PDT) schrieb :

'Make Event Budget Inputs sheet active
Sheets("Event Budget Inputs").Activate


you forgot to inizialize emptyRow.
Change the line above:

'Make Event Budget Inputs sheet active
Sheets("Event Budget Inputs").Activate
emptyRow = ActiveSheet.Cells(Rows.Count, "C").End(xlUp)(2).Row


Regards
Claus B.
--
Windows10
Office 2016