Search results

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.

Hi All, Here in the attached data I have some duplicates IDs , I want to copy all the remarks if available and paste in-front of the single unique Id. Lets take a visible example:- If I have ID (101) four time in the data:- ID Remarks 101 A 101 B 101 A 101 C Output should Like...

Hi all, I have done something to connect the excel vba with access database, all the things I have done but whenever I am trying to delete the data or trying to insert new record the event is not working, but when I reload the same form then the database is showing the updated values. Where I...

thank u so much appreciated.

Hi All, i am trying to count the unique date count from a range which is based on two criteria. example sheet attached pls help or share you thoughts. i have found the unique date count by the:- sumproduct(1/countif(Range,Criteria) but if i have some name and week name also in terms of...

Hi All, my confusion is :- I am entering some data in to the vba form at Run time, and I need to open another excel sheet at that time any idea I can I do that. Please suggest.. Thanks Nipendra

thanks you so much it's working fine

Does this question make sense. Please share your thoughts.... Warm Regards Nipendra

Hi all, Here I am in between my code please help if anybody can.. I want to add multiple values by dropdown but it should be basis on the number count which is in sheet2, like formatting should be count of 6 only not more than that if user is trying to select the formatting after count of 6...

Somendras thank you so much for your prompt response cheers.. Nipendra

and plz ignore the first attached sheet