View Single Post
 
Old 08-18-2011, 06:33 AM
tinfanide tinfanide is offline Windows XP Office 2010 32bit
Expert
 
Join Date: Aug 2011
Posts: 312
tinfanide is on a distinguished road
Default

Quote:
Originally Posted by Catalin.B View Post
here is a sample attached...
Make sure you have macro security set to "disable all macros, with notification"
and when you open this workbook, in the message bar click options-enable this macro
Yes, thank you very much for ya file.
The only thing that goes wrong is that when I expand the table (I set the A column a table) but for whatever reasons I didn't enter a new date. So the lastrow is empty, Excel asks me to debug the line:

Code:
Cells(1, 1).Value = Cells(lastrow, 1).Value - Cells(2, 1).Value
Reply With Quote