Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #11  
Old 08-18-2011, 06:33 AM
tinfanide tinfanide is offline Date Subtraction Windows XP Date Subtraction Office 2010 32bit
Expert
Date Subtraction
 
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
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Date formatting kjxavier Excel 0 08-10-2011 08:17 AM
Date Subtraction Need a date formula MPAVLAS Excel 3 08-12-2010 10:04 PM
Date Subtraction Julian Date windseaker Excel 1 02-14-2010 01:44 AM
new appointment date always reverts back to today's date msills Outlook 0 08-24-2007 08:57 AM
Date Subtraction Imported message date change to today's date promark Outlook 1 12-23-2005 07:21 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:58 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft