Tricky date variable issue???

[Apollo6]

I move =Now()-15 into a cell. Copy the cell and special paste/paste value back into the same cell. This gives me the date of 15 days ago and also "Hardcodes" it so I don't have the formula anymore. I then format it to "mmm-yy" to reflect, Dec-02.

So, activecell.value = '12/01/2002 3:49:19pm'
activecell format = "mmm-yy"
Displays in a cell as 'Dec-02'

Problem:

How can I move what is actually displayed into a variable?
Not the activecell.value: '12/01/2002 3:49:19pm'...

Please let me know if this is not clear.

 

[vb5prgrmr]

ActiveCell.Text ???

 

[kylua]

Use activecell.text as opposed to activecell.value

 

[Apollo6]

Thanks for both of your responses. I thought I had tried using the activecell.text and it didn't work. I have since tried it again, and yes that would be what I need. I'm not sure what happened on my first attempt but it's a non-issue now.

Thanks again!