Search results

Hey Hui, Thanks for the Quick reply.. I want the filter to show only one value eventhough it has a lot of options. eg 2010.Rest I don't want users to change or give them an option to change in the field header.Is it possible? -Thanks Dinesh

Hi, I have a set of data which has a column with years eg:2001,2002..20110. I would like to show only 2010 in the report filter. Is there any way to do this? -Dinesh

Hey rjwalters, I generally use this method to protect cells with formula. Select the entire range where formula and data resides. Right click and select Format Cells. Under Protection tab uncheck Locked. Again select only those cells where the formula is and select Format cells and under...

Hey Luke , The Formula Works Perfect ...Thanks A ton. @ NARAYANK991 thanks a lot for the alternate method. -Dinesh

I went through the forum and viewed text sorting using formula's but could not get.. What I would like to do is I have a list if text as below A Z D B C To A B C Z D I want to sort it to in ascending order Except D as i always want this in last .

Ok Hui, i will try to re-install office on Monday and see what happens. Thanks a lot for your time and guidance. -dinesh

Hey hui, yeah, I re-installed the addin but didn't work . The add-In was developed by me :-). My colleagues have installed and they haven't got any problem . Should I reinstall Office? -Dinesh

Hey Hui, I have installed 32 bit and my add-in sits at C:UsersXXXXAppDataRoamingMicrosoftAddIns -Dinesh

Recently my system got upgraded to Windows 7, My addin is loaded and it shows in the ribbon but when I click nothing is happening. I have enabled all macros in trust center settings. I am using Win 7 & Excel 2007(Addin developed in 2007 with XP). Please let me know if you have any solutions.

Hey Busymanjohn, We are glad that you got it. -Dinesh

Hey Suri, let me know if this works Sub deleteRows() Dim i As Long, lastRow As Long lastRow = 10 For i = lastRow To 1 Step -1 If ActiveSheet.Cells(i, 1).Interior.Color = 16777215 Then ActiveSheet.Rows(i & ":" & i).EntireRow.Delete End If Next i End Sub -Dinesh

Hey Kaushik, No problem I was not able to figure out why the code is not working for Busymanjohn... I am glad that you were able to help Busymanjohn. @Busymanjohn : Please let us know if you still face problem -Dinesh

Hey Kiran, Let me know if this works ... add this code in the sheet where the form reseides Private Sub Worksheet_Change(ByVal Target As Range) If Target = Range("B5") Then Application.DisplayAlerts = False ActiveWorkbook.SaveAs Filename:="C:XXX" & Range("B5").Text & ".xlsx"...

Hey , Can you post a sample worksheet.. -Dinesh

Hey, In the Form select the command button you have and right click on it and select view code . you would get the VBE window.. There add the code I have provided. Let me know if this is not clear...

Hey , In Onclick event of the button add the below code ComboBox1.Value = "<Select>" ComboBox2.Value = "<Select>" Thanks, Dinesh

Hey Kumar , Let me know if this works out http://speedy.sh/w23Yf/SampleTest-Final.xlsm -Dinesh

Hi Faseeh, Thanks a ton.. The new workbook does the magic. Thanks a ton again for helping me.. -Dinesh

Hi Faseeh, Thanks a lot for taking time to help me with the issue.. The problem still seems to be there . Eg: When I select NorthAmerica and select Canada the countryIndex(cell M2) shows correctly. From NorthAmerica if I select EMEA which has only one country UK the cell link still shows 2...

I have created a dependent combo box (Form controls). I am filling the data for the combo boxes using named ranges.Each combo box is lined to a cell to get the index. The problem I am facing is the cell link(for Country) is not updating when the combo box has only one value. I have sample...