End of Day

[austinpcherry]

I have several spreadsheets that get data from one another in an ongoing manner (formulas directly in the cells). At the end of the day, however, I need a way to make the current values static. I know there is a way to do so in VBA but for the life of me I don't remember how. Help please.

 

[MARK858]

Range(yourRange).Value = Range(yourRange).Value

 

[austinpcherry]

Thank you. I guess if you don't use it you lose it applies.