Search results

Hi Kevin, You formula is awesome, working smoothly. You are genius. Thanks, I learned new formula today. Thanks & Regards, Anupam

Hi Suri, Considering that the value BLR5658DTDC is in cell A1 and 3866DTDCBLR is in cell A2 Please use the below formula to extract numbers from the examples you have given...

Hi Sonia, Please try the below one and let us know if its working fine for you. =IF(N44="","",CHAR(43)&CHAR(10)&N44) Or =IF(N44="","",CHAR(43)&N44) Thanks & Regards, Anupam Tiwari

Hi akmalkhan, Please try below code:- Sub RenameSheetNames() Dim NewWb As Workbook Dim myFileName As String Dim myFileFolder As String Dim sh As Worksheet Application.ScreenUpdating = False Application.DisplayAlerts = False myFileFolder = "C:UsersAnupamDesktopDummy" 'Change the...

Hi akmalkhan I have written the below code which is working perfectly. Please try it. Sub RenameSheetNames() Dim NewWb As Workbook Dim myFileName As String Dim myFileFolder As String Application.ScreenUpdating = False Application.DisplayAlerts = False myFileFolder =...

Hi Jignesh, Welcome to Chandoo.org. I tried the below formula on your given data and its working fine for me however the solution may not be good enough so will wait for our excel experts to provide us a better solution. Suppose your Score is in A column, Achievement in B and Grade in C...

Hi inbp, Please check the below link. http://www.vbaexpress.com/forum/showthread.php?t=693 Hope this will help you out. Thanks & Regards, Anupam

Hi Tanner, I have not understood your requirement very well however tried something like below that can may help you. Please try and let me know. Sub ReplaceErrorValue() Dim cell As Range For Each cell In ActiveSheet.UsedRange If IsError(cell) = True Then cell.Value = "invalid...

Hi Deb, You are genius. Its working absolutely fine for me. Thanks a lot for your assistance. The Forum Rocks as always. Thanks & Regards, Anupam

Hi Excel Ninjas and All, Happy New Year. I need your help to resolve my query. I have very weird data in column A explained as below: 1. 195 AS U320 IAF-CHKDISK V2.0 Checklist 2. 200 DF AS JHK C2 CDIndia String to be deleted from above 1. Checklist 2. India The remaining string...

Hi Hui, I was not sure out of the above two symbols which to use for indentation however thanks a lot for your help to clear my confusion. I will remeber to use "`" while posting code. Thanks & Regards, Anupam Tiwari

Hi shrivallabha, Thanks for correcting me. I have tweaked my above code to below that could be much better now. 1. Code to put in click event of commandbutton on userform1. If IsNumber(UserForm1.TextBox1.Value) = False Or IsNumber(UserForm1.TextBox2.Value) = False Then...

Hi Mahaveer, You can put the below code in click event of commandbutton on userform1. UserForm2.TextBox1.Value = CInt(UserForm1.TextBox1) + CInt(UserForm1.TextBox2) Unload Me UserForm2.Show Hope this may help to resolve your problem. Please let me know if you find any issue...

Hello Narayan/Kaushik, Thanks a lot for your assistance. Above links provided could not resolve my problem completely however the above links help me a lot to reach the solution as I have browsed the forum in the above OZGRID link and found the exact solution what I was looking for. Here...

Hi Hui, Sorry, forgot to clarify that thing, the userform is a VBA Userform where I am having the above mentioned problem. Thanks & Regards, Anupam

Hi All Excel Gurus, I need your help to resolve my query regarding resize of userform in Excel. Issue:- I have designed an Userform which is working best on my laptop however when I am running the same on my PC, its not showing completely just because of different resolution. I have...

Hi Deb, Below is my tested code for your problem. Sub SelectMultipleSheetsAtOnce() Application.DisplayAlerts = False Dim shtAry() For d = 2 To ActiveWorkbook.Worksheets.Count ReDim Preserve shtAry(d - 2) Order = ActiveWorkbook.Sheets(d).Name shtAry(d - 2) = Order Next d...

Hi Deb, Hope below hint will help to resolve your proble. Sheets(shtAry()).Select just tweak your code line "Sheets(shtAry).Select" in your macro to above, as I have checked, its working fine for me. Thanks & Regards, Anupam Tiwari

Hi Mandar, Could you please provide some more details what exactly do you want? Thanks & Regards, Anupam Tiwari

@Hui, Thanks a lot Hui for your help, as always you provide with very nice solutions. your solution is working fine however I have just tweaked as below {=SMALL(FIND({0,1,2,3,4,5,6,7,8,9},A1&{0,1,2,3,4,5,6,7,8,9}),$B$1)} where $B$1 cell will have nth occurence number so its giving me any...

Hi shrivallabha, You are genius, the formula is working fine for me, giving result what i wanted. Thanks a lot for your help. Regards, Anupam Tiwari

Hi All, I need your help to know the nth occurence of a number in a Text or String. For example, I have written "anupam53" in cell A1 and now I want the position of first occurence of a number e.g. 5 here or may be 2nd occurence e.g. 3 within this text. I have tried below array formula but...

Hi SirJB7, Congratulations for sharing your knowledge with all of us and achieving the milestone. Thanks & Regards, Anupam Tiwari

Hi Deb, Very helpful link, you shared. Thanks, Anupam

Hi Deb, I have both 2003 and 2007 however that filter part being not used, missed out how to use. By the way thanks for your help. Regards, Anupam Tiwari