Hi, I do not know macros. There was a excel macro sheet sent for my use. On opening it, I receive compile error. On clicking ok, button, on opening the excel sheet, there are value, name NA errors all thro the workbook. It was a workbook with macros version 97-2003.
Elsewhere in the discussion...
Hi, If it all what you cannot change is the parents and relatives and their relations in this world. I really lack the details on the heriditary details of a family member and his sons daughters , son in law and daughter in law. As we pass on and grow old, we could not remember the heriditary...
Hi,
Is there a simple way to solve the Rubic cube. I know it has edge pieces, and centre pieces and 3 rows and their move are restricted to spin and rotate.
Is there a way, excel way, to how to solve the scrambled cube...
Hi,
When i format a cell with time or date, i have to format the cell and also has to type manually the / / or -- format for date or : for time. Is there any tip, or function in excel where in it is possible to auto separate the entries according to chosen format. For eg. when i...
Hi,
i am having a excel sheet in which i and my staff will be updating. This is a regular worksheet, having names and some data.
I will be updating the data to selected rows,this week, some other rows in next week and so on. It gets updated...
When a question is solved, if it is marked as solved then any search engine user, if searching may find it very useful as SOLVED one.
Normally user search for excel and other questions, by including solved as a starting string in the question. for eg Solved How to change the...
The question is about bordering in excel. I could change the font colour , but could not change a colour line of the border in excel 2007. How to do that . I am having excel ribbon
Hi,
i know how to use if function for general equations. But how to write formula to say, to find a particular number, and if those are present in all of them, i want to have the if function to get a result. if for example, if a1 to a6 contain 200, then i should get 150 in a7. in a...
I have copied one table having automatic border , black colour, to a word as a table and then i typed on it and saved that table as word file. I could just select the total words to change its colours of my choice. But while selecting all, everything font colour changed all over the doucment...
if suppose some due date is available in a cell or cells in a worksheet/s, is it possible to have a kind of above alert, when the date and time passes, like gmail alert thro gmail notifier. I read in a thread that it could be done with linking to outlook. But outlook, by default, if used swallow...
http://chandoo.org/wp/2009/01/22/hide-excel-worksheet-tab/
is the article concerned. In this article, you have given the excel ideas to hide sheet from viewing using excel menu commands. I want to know, how to view the sheet again using the excel menu. I had made sheet2 to be hidden by your...