tion to this UDF: There are certain symbol characters
> that the KeyValue can't contain or the UDF will malfunction. That's
> because not all characters can be stored in a cell's ID property (the ID
> property is designed for HTML export use).
>
> ** **
>
> To see how the old date and KeyVa
ID property is
designed for HTML export use).
To see how the old date and KeyValue (or serial number) is stored, you can
use this UDF to view the hidden info:
Function id(ref As Range)
Application.Volatile
id = ref.id
End Function
Asa
From: excel-macros@googlegroups.com [mailto:excel-ma
hen Exit Sub
Target.Offset(, 1) = Date
End Sub
Don Guillett
SalesAid Software
dguille...@gmail.com
From: Abhishek Jain
Sent: Friday, February 17, 2012 6:01 AM
To: excel-macros@googlegroups.com
Cc: kalx...@gmail.com
Subject: Re: $$Excel-Macros$$ Date (value pest) query
I think this is what you n
I think this is what you need. It will enter current system date when you
add a new serial no. and once entered, will not change it, yesterday,
today, tomorrow, ever, :)
PS: A one line macro is used, so enable macros.
Let me know if this doesn't solve your query.
Cheers!
AJ
On Fri, Feb 17, 2
Dear Priyanka,
Thanks for your super fast reply.
I have some queries
1. At C2 there is today(), today it is 17th, tomorrow that will be 18
and all date under C2 will change, so what will be the solution
2. If I gap one day…..suppose there is no entry on 18th , so how it
calculat
kindly find the attached file
On Fri, Feb 17, 2012 at 4:30 PM, Kal xcel wrote:
> Dear Experts,
>
>
>
> I am trying to make a document tracker, where I want to put date
> automatically. If you see the attachment, when I am giving serial no.
> Document no. & date will be appeared automatically. Bu
Dear Experts,
I am trying to make a document tracker, where I want to put date
automatically. If you see the attachment, when I am giving serial no.
Document no. & date will be appeared automatically. But next day that date
changing to current date which I don’t want.
Is there any process to ke
