Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old February 23rd 17, 10:13 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2015
Posts: 114
Default Why this date result?

Hopefully self-explanatory illustration:

https://dl.dropboxusercontent.com/u/...Variations.jpg

--
Terry, East Grinstead, UK

  #2   Report Post  
Old February 24th 17, 10:56 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2015
Posts: 114
Default Why this date result?

Terry Pinnell wrote:

Hopefully self-explanatory illustration:

https://dl.dropboxusercontent.com/u/...Variations.jpg


Now sorted.

I tried to avoid getting into potentially confusing details, but in case
anyone is curious: the window showing '20010709' was actually displayed
by a script I'd written with my macro-writing app, Macro Express Pro. It
operates on two worksheets, successively copying some 40 cells from one
sheet to the other (because my VBA skills are now negligible). It works
perfectly, albeit glacially slowly, on all cells ... except B6. I was so
focused on the fact that this cell was a date (with its potential
formatting issues) that I didn't look harder enough at other
alternatives. When I did, I discovered that, for just that cell, my
script had failed to change focus from the destination sheet back to the
source sheet. So '20010709' is the content of B6 in the destination!

--
Terry, East Grinstead, UK


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Result Based on Date Criteria pobm62 Excel Discussion (Misc queries) 6 November 1st 06 11:07 PM
Can Excel add working days to a date to result in another date? cwalrus Excel Worksheet Functions 1 May 16th 06 07:27 PM
Translate WEEKNUM result into a date Wil Excel Worksheet Functions 2 September 8th 05 01:26 PM
fixing the result of a formula after a certain date Rein Excel Programming 2 April 11th 05 02:37 PM
Sum formula result expressed as a date Robert E Hansen Excel Discussion (Misc queries) 1 January 11th 05 01:13 AM


All times are GMT +1. The time now is 03:31 AM.

Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017