Melcor Real Estate Investment Trust (There is no graph of the growth in revenues and earnings per unit because the REIT has only about three years of history.) Melcor Real Estate Investment Trust (MR.UN, Toronto) RESEARCH SUMMARY Report Author(s): InvestorsFriend Inc. Melcor Real Estate Investment Trust (There is no graph of the growth in revenues and earnings per unit because the REIT has only about three years of history.) Melcor Real Estate Investment Trust (MR.UN, Toronto) RESEARCH SUMMARY Report Author(s): InvestorsFriend Inc. Analyst(s) Author(s)' disclosure of share ownership
Home/VBA Code Explorer/Application/Methods/Wait. Wait Application Method in VBA is used to pauses or stop a running macro until a specified or mentioned time. It returns a Boolean value either true or false. If the specified time arrived, it returns true otherwise it returns False.
Do it on your =NOW() formula, and it should stay fixed. I would try inserting the current date into a cell via a macro. The question then only is, when and how to trigger that. You could for example press a button and it would insert today's date (not as a formula) into a cell (one particular or the selected one). In VBA you can use Now(), Date() and Time(), depending on what you need exactly.