Recent content by Nipendra.dhiman

Got the solution thank you Guys

Thank u for the response i have tried it and getting the error method range failed

Please rply little urgnt

Hi All, i need to select and copy different ranges in excel but i am stuck please suggest. j=2 i am using below:- Range("T" & j & ":AA" & j, "AM" & j).Select giving wrong selection selecting T to AM Thanks Nipen

hi all i have some data for august month which is in form of 1 to 31 August datewise, i want to reverse this data in to 31 to 1 the latest date should come in first Any idea Regards Nipen

i have tried this method but same situation nothing is changing i have change B to x and saved still it will asking for password

so how to open it please suggest some help

Guys any Idea please share if you can for above query. Regards Nipendra

Anyone.

even i have tried to open it with open office again asking for password any help

Hey Faseeh, Open Office i dint get that could you open and try it Please. Regards Nipen

Hi Deepak, Thank you for your prompt response but i have done all these R&D even not able to open the file now please have a look to open it, need to give the password at opening event and if i will go with cancel then the sheet will automatically closed, so there is nothing to run macro all...

Hi Folks, i have tried all my mind to remember the password but not reached and i got stuck somewhere i need this file for one of my processes please suggest the idea or take a look of that. i need to unprotect it and want to change the new password. Best Regards Nipendra

It works perfect really appreciated Thanks a lot. i wish, one day i will be able to do the same. Nipendra

Thank you Jaya i was an awesome one by using formula but this time i am trying to do by vba only. Appreciated Your Quick response.