![]() ![]() So far, therefore, as the Central Assembly is concerned, there is really no change effected by this new article 79-A, because what is provided in clause (1) of article 79-A is already a fact in existence. Ultimately, the Executive Government in 1928 or 1929 gave in and accepted the contention of the then President and created an independent secretariat for the Assembly. The Executive Government of the day, on the other hand, contended that the Executive had the right to nominate, irrespective of the wishes and the control of the President the personnel and the staff required to serve the purposes of the Legislative Assembly. The President had contended that the Secretariat of the Assembly should be independent of the Executive Government. A dispute was going on between the Executive Government and the President of the Assembly. Vithalbhai Patel was called upon to occupy the President’s Chair in the Assembly. It was, as everyone most probably in this House knows, a matter of contention between the Executive Government and the President ever since the late Mr. after consultation with the Speaker of the House of the People or the Chairman of the Council of States, as the case may be, make rules regulating the recruitment and the conditions of service of persons appointed to the secretarial staff of the House of the People or the Council of States, and any rules so made shall have effect subject to the provisions of any law made under the said clause.” (3)Until provision is made by Parliament under clause (2) of this article, the President may. (2)Parliament may by law regulate the recruitment, and the conditions of service of persons appointed, to the secretarial staff of either House of Parliament. (1) Each House of Parliament shall have a separate Secretarial Staff: Provided that nothing in this clause shall be construed as preventing the creation of posts common to both Houses of Parliament. 1 of List I (First Week) of Amendments to Amendments for the provisions of any law made under the said clause.” Secretariat of Parliament “79-A. I would also like you, Sir, to fix the dates when questions of National Language, National Anthem and the name of the country would be taken up here so that the people, may come to know of the dates when these questions would be decided. Unless it is so done, in my opinion, our Constitution would remain incomplete. I would like you, Sir, to contradict these rumours and make a definite announcement that the question of the National Language would not be left to the Parliament but that it would be decided by the Constituent Assembly. Now we are holding the final session, and I have learnt that the Translation Committee appointed by you for preparing the Hindi translation of the Draft Constitution has already translated the articles so far adopted by this Assembly. Sir, you have said here repeatedly that not only would the question of our National Language be decided by us here, but that our Constitution too would be adopted in our National Language. It is said that the question of National Language would now be left for Parliament to decide. Since the day of our arrival here we have been hearing various rumours about our National Language. President, before we proceed with our business, I would like to draw your attention to one matter. You just have to remove arrows at the end of the code.: Mr. Probably not the most efficient way to do it, but as far as I know, it works. I got it working, I had to do: Worksheets("Sensitivity Table").Activate I did some research and found a lot of answers that just said "Use ", which I did, and it didn't work. I then tested a macro using a different cell as the precedent on the same sheet (so U5 was linked to V5, instead of the cell on the other sheet), and it was able to select the precedent cell. Because the precedent I am trying to link to is on a different sheet (still in the same workbook) it returns "Run-time error '1004': No cells were found."īecause this did not work, I went to the "Trace Precedents" button on the Formula Auditing tab, and it was able to trace back to the precedent on the other sheet (ctrl-[ also worked to select the cell). I looked up how to code it in Visual Basic and ended up using "" to trace the cell's precedents. I was mostly doing this through the "Record Macro" function, as I am not knowledgeable in Visual Basic to code it myself, and there is not enough time to learn the language.Īll was going smoothly until I learned that ctrl-[ would not work to trace a cell's precedents inside of a macro because it just selected the cell that the first precedent was linked to, and would not change for future precedents. I recently started working with a friend's excel project, making macros.
0 Comments
Leave a Reply. |