Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Have posted this eror before with no replies.
################################################## ########### Sub callUpdates() Sheets("Enter - Exit").Select ' Sheet name Dim ws As Worksheet Application.ScreenUpdating = False For Each ws In Application.Worksheets ws.Select With Range("E2") ' Date value displayed a 31 October 2006 ..Value = Range("E2").Value + 7 ' Should add 7 days to currently displayed date value End With Next Sheets("Enter - Exit").Select Application.ScreenUpdating = True Application.DisplayAlerts = True End Sub ################################################## ########## The above code suppose to add 7 days to a date value in Cell E2, Yet sometimes it works fine, yet other times it jumps 6 months backwards from 31 October 2006 - 11 July 2006. Why ? Is there an error in the code? Corey.... |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
merged cells - code glitch | Excel Discussion (Misc queries) | |||
Is there a Glitch in this code or what ? Not consistant results !!! | Excel Programming | |||
Strange glitch | Excel Programming | |||
Random glitch? | Excel Programming | |||
Code Glitch from version to version | Excel Programming |