Search results

Congrats HUI Sir.... i have learned a lot from your posts.

thanks Narayank... for help..can u please suggest on below mention point also.. if in same sequence if score 3 also get added but we still require the last address of ("score 2 cell written") then what should we do..

yes, i can but is there any other better solution for same for n number of length can u please help...and one more... if in same sequence if score 3 also get added but we still require the last address of ("score 2 cell written") then what should we do.. Any Help will be highly appreciated

i don't know... previously it was not working :( Else.. thanks to all for this.. Can anyone please suggest what should i do if i don't want to stick formula with a specific column (AH) ..or we say that ...if data get extends from AH then..? what should be the formula for same..? Please Help!!

can anyone please help out for same. i want excel formula/VBA code to find out the address of last NON EMPTY CELL in a specific row. i had tried the below one but wrong result found. please HELP :( =ADDRESS(ROW($A$4),MAX(NOT(ISBLANK($A4:$AH4))*COLUMN($A4:$AH4)))..... with Ctrl+shift+enter...

thanks to both of you... error resolved...... in window 7 - SP1 pack was missing... Thanks

https://www.dropbox.com/s/xllvw16vrgi3uzq/Project%20KRAs.xlsm Link attached, Error occurring area:- con.ConnectionString = scon con.Open rs.Open xselect, con

hi, Please clarification required!!! =A1&" "&LEN(A1) in which cell we are using this formula?, because we cant use this thing in A1 itself..(circular reference)

Hi, can anyone help me to update msado15.dll in active x control. I had coded VBA program through which we can extract MS-Access table and displays it on Excel.previously this program works very fine, but after getting system formatting it sows the error (Run time Error - 430 Class does not...

Hi all, can anyone suggest the VBA code to create a loop depend on check box value. what exactly i want... There are 50 check boxes on a sheet.. for true value of each check box its corresponding cell text get uploaded in db..as like If .CheckBox1.Value = True Then...

Thank you SP :) You have resolved my Issue. Can you please help me little more.... for every new entry in column (A) i have to copy the below mention code as well...this code is linked with access DB... Sub smittal() Dim scon As String Dim con As New ADODB.Connection Dim rs...

Hi SP, Apology for Miss-confusing @ Drop box. Thanks for the Above link... this is the Exactly same which i was looking for. Will try and Update on post.

Hi SP.. I already have a Drop box account. can you please share your ID to share folder with you. thanks in Advance smittal

thanks a ton :) but need to know in which Module i have to apply this code... i had used this in DB sheet but its not working there... please confirm where i need to use i have used various modules.. either i used anyone of that or i create a new module for same.... or :P Appreciate...

Hi.. Myself Shweta and i m SR. MIS Executive and working in India. i love this forum because it helps me a lot whenever i stuck somewhere. At all finally Love it....

Hi, I am Beginner in VBA. i am working on a project in which if you update any client name in your db and tagged with project manager then it will automatically link with Project manager sheet. Now, i want to add a new worksheet for every new entry in column A ... means column A of...