Hi, I am trying write a macros to convert Now ...

Hi,

I am trying write a macros to convert Now() funtion to it equal value in a different cell by clicking a comand button, the value should not refresh like NOw() function whenever the file is opened or another value is entered

Answer this question

Topics:

excel

Posted 2009-09-20T06:59:59Z
36 views
0 watchers
Reply
Edit

Send to a friend

Watch

Report

Posted Answers

No answers were posted yet - be the first one to answer!

Sign in to participate

Got an answer for Abhishek@Yedda? Would you like to comment on the posted answers, or vote for the one which you think is the best?

Explore Related Posts in Forums

copy current excel data to a new excel file

HI, anyone know how to copy a range of data from current excel to a new excel or sheet1 to sheet2 ? how to read columns? Lets say, range A1:A15, A17:A27, etc.. to a new excel file/sheet. You can copy a sheet, by right click the sheet tab at the botttom of the excel workbook

Unable to open Excel 2003 files with Excel 2007

I have recently installed Excel 2007.My OS is windows Vista I am unable to open excel files of previous versions directly by clicking. To open a previous version file, I have to open Excel 2007 first Seems to be a file association issue (unless there's a specific error from Excel 2007,which you

Pivot Table: How to block users from opening the Excel Workbook in Excel ...

I habe used the Excel Services to show Users of the SharePoint site a Pivot Table. I would like the users not to be able to open the Excel Workbook in Excel itsself. How can I do this? setting in the workbook itself that affests this?You can uncheck the Open in Excel, Open Snapshot