Excel 97 Macros

[vincej]

I created a macro using Excel 97 and am trying to get it to run within Excel 2000. Excel 2000 recognizes part of the macro command, but the other part it cannot load. The part of the macro not functioning properly is a date insert, which is 'Date' in 97. What is the correct command, if there is one, that will insert the date properly regardless if I am using 97 or 2000?

 

[acron]

Date also returns the current in XL2000.

Could you post the code that is giving problems ?

In the meantime, check (in VBE) Tools, References and check to see if any are marked MISSING. If so unselect them and that may resolve the problem.

A.C.

 

[vincej]

Here is the macro...

Private Sub Tog_C11_Click()
If Tog_C11.Value = True Then

Range("C7:C11&quot.Select
With Selection.Interior
.ColorIndex = 6
.Pattern = xlSolid
End With
Range("C11&quot.Select
ActiveCell.FormulaR1C1 = Date
Else

Range("C7:C11&quot.Select
Selection.Interior.ColorIndex = xlNone
Range("C11&quot.Select
Selection.ClearContents
End If
End Sub

 

[VulcanJedi]

just try activecell = date (this will actually leave the static date ) so it want change unless code is executed
otherwise try ActiveCell.FormulaR1C1 = "=today()" Tranpkp
************************************
- Let me know if this helped/worked!
Remember to give helpful posts the stars they deserve, this facilitates others navigating through the threads / posts!