All About Klick2Learn More

Answer

You get name error when you write a word in Excel which is not recognised by Excel. For example if aplying vlookup in Excel if I will misspell and write =Vlukup then I will get #Name Error.

Answer

Answer

Right Click on Cell>>> click on Format Cells>> there you can find all the options to format the cell.

Answer

Press ALT+F11 key there you will see the coding of your macro.. Copy that code and paste in anyversion of Excel you want.

Answer

IF Function in Excel, Returns two values one for true and one for false based on your logic. For example in cell A1 25 is written, and in Cell B1 you want to apply IF function checking that if the value in cell A1 is greater than 20 then you want in B1 to be written Yes otherwise no. So in B1 you will write =if(A1>20,"Yes","No") 

Answer

Open VB Editor Click on Tools Click on VB Project Properties Click on Protection Check on Lock Project for Viewing In the Password section give a Password In the confirm Password section give same password again Click on OK And Save Now next when you will try to see your code you will have to give the password.