Value2 always uses the same value that Excel uses. It does not truncate
decimal places ,Value2 gives you DateSerial so you know exactly which day
is meant. Same thing with currency and decimal/digit grouping symbols.
.
Enjoy
Team XLS
On Thu, Oct 24, 2013 at 9:29 AM,
Thanks a lot Sir,
Sir ..can you share one example for the same if possible.
*Regards,
Prafull Jadhav
9920553518*
On Thu, Oct 24, 2013 at 1:00 PM, xlstime xlst...@gmail.com wrote:
Value2 always uses the same value that Excel uses. It does not truncate
decimal places ,Value2 gives you
sub rr()
range(a1).value =date
range(a2).value2=date
end sub
.
Enjoy
Team XLS
On Thu, Oct 24, 2013 at 1:31 PM, Prafull Jadhav prafulltjad...@gmail.comwrote:
Thanks a lot Sir,
Sir ..can you share one example for the same if possible.
*Regards,
Prafull Jadhav
Got it !
Thanks a lot
Regard,
Prafull Jadhav.
9920553518
On 24-Oct-2013 1:37 PM, xlstime xlst...@gmail.com wrote:
sub rr()
range(a1).value =date
range(a2).value2=date
end sub
.
Enjoy
Team XLS
On Thu, Oct 24, 2013 at 1:31 PM, Prafull Jadhav
Dear All ,
Very GooD Morning and Have a Great Day!
I have one query in VBA what is Value 2 . i know Value
When and Why Value 2 is use in VBA Code.
Appreciate cooperation expected from you
*Regards,
Prafull Jadhav
9920553518*
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna