• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. D

    Macro - Delete blank cells - problem

    Thanks Hui and Marc L. But still it is taking time. Any other solution you have?
  2. D

    Macro - Delete blank cells - problem

    Also I tried with this code. Dim myColm As Range Set myColm = Range("C:C") myColm.SpecialCells(xlCellTypeBlanks).EntireRow.Delete End Sub As I already mentioned in my first post, i am using formulas and it is not deleting the rows which has formulas.
  3. D

    Macro - Delete blank cells - problem

    Thanks Deb. It works.! But my actual row range is 15 to 1652. It takes more than 3 mins to delete the rows. Is there any possibility to reduce the time?
  4. D

    Macro - Delete blank cells - problem

    Hi I need to delete all rows if if the cell in U column is blank. Sub a() Worksheets("Testing Execution Data").Select For i = 15 To 100 If Cells(i, 21).Value = "" Then Cells(i, 21).Select Rows(ActiveCell.Row).Select Selection.Delete Shift:=xlUp End If Next End Sub But it is...
  5. D

    Dynamic chart range remove blank legend

    Sample file: http://www.2shared.com/file/DsLx5t39/Dynamic_Chart.html
  6. D

    Dynamic chart range remove blank legend

    Hi I have a chart in a sheet and data in other sheet. The data range may vary then and there. Data: B2 to Q3 (sheetname: Test Execution Data) chart name: Chart 1 (sheetname: Dashboard) Problem: If I have no data in column Q, then the legend color should not be shown in chart. But it is...
  7. D

    Congratulation Luke - 4,000 Posts

    Congratulations Luke. Love your techniques..!!
  8. D

    plz help me

    Jai's formula will also work with a slight modification. =IF(LEFT(A1,2)="08",REPLACE(A1,1,2,""),A1)
  9. D

    plz help me

    Try this. Assuming your data are in column A and from row 1. B1=IF(MID(A1,1,2)<>"08",A1,MID(A1,3,100))
  10. D

    Ctrl shift and arrow keys

    GGGGG, First you will have to name the whole cells as a table. This is one time work, just follow the steps given below. 1. Select all cells (First cell and last cell) 2. Go to Formula menu 3. Select define name 4. Enter the name (eg : "ggggg") 5. Click ok. That't it. Now click any...
  11. D

    Concatenate acting funky

    You mean, C1 is displaying this (=a1&" "&b1) instead of 123 Stone Street Apt. #4.? if yes, please disable viewing the formulas(Excel menu - Formulas - Show formulas). If I am wrong, please post a sample file to analysis further. =a1&b1 will do the same as what concatenate(A1,B1) will do...
  12. D

    Concatenate acting funky

    Assuming your values are at first row. Please change the row number according to your data.
  13. D

    Concatenate acting funky

    Hi Hayley, Try this in column c. =a1&" "&b1
  14. D

    selection of next name in data validation drop down list through vba

    Hi itisalikhan, It can easily be done with vba. Taking the total names count and changing the drop down values with the help of print code will do what you are looking for. Please post a sample file for more analysis.
  15. D

    Macro takes around 40 minutes to run

    Hi sachinbizboy, Can you please post the data.xlsx and new.xlsx workbooks?
  16. D

    Creating Custom Screens with Userform

    Hi Susan J, PFB the file you are looking for. http://www.2shared.com/file/9PEm_3u_/CVR_0204021.html
  17. D

    Tbl Col width changes while pasting from excel to outlook body in html format

    Hi Kaushik, Did you try copy the range from worksheet and paste it into outlook manually? Did you see any difference in col width? If you see any difference in the above case, there will not be any options afaik.
  18. D

    Populate details based on combo box value: [VBA]

    Hi Vijay.vizzu Private Sub ComboBox1_Change() Label1.Caption = ComboBox1.Text End Sub
  19. D

    ARRANGEMENT , HELP!

    Hi lalit232 Do you want like this? T2 T2 T2 E-117 E-125 E-125 E-124 E-124 E-124 Can you please post a sample workbook? since we are not aware where you want to have the output.
  20. D

    Extracting specific numbers from a sequence and converting to year of birth

    Hi Katrinthor. The number is 010474-5589 and the year would be 1974. If I am not wrong, when the number is 010404-5589, It should return 2004. In that case you can use this. =IF(MID(A1,5,1)<>"0","19"&MID(A1,5,2),"20"&MID(A1,5,2)) You might need this in future. Thanks
  21. D

    n.... no. of dates?

    1. In C1, =b1. 2. select c1, ctrl+1, Number - Custom - mmm'yy - Enter. 3. Drag it till where you want to. Thats it.
  22. D

    Formula to ignore if criteria not met for extracting certain text

    =IFERROR(MID(C3,FIND("By:",C3)+4,6),"")
  23. D

    Excel Ribbon Menu - creation - help needed

    XML Code: <button id="customButton1" label="Serial Number" size="normal" onAction="Pop_S_nO" imageMso="AccountMenu" /> Also I changed the file format as add-in (*xla). Please reply if you need more details.
  24. D

    Excel Ribbon Menu - creation - help needed

    Thanks DB and Narayan. The button in Ribbon is working fine if I have full code in Module. But getting error if i call a user form from the module. Module Sample code: Sub Pop_S_nO(control As IRibbonControl) Pop_SNo_Uf.Show vbModeless End Sub In User form, the code will populate serial...
  25. D

    Undo options - After Running a macro

    Hi, How to revert changes after running a macro?
Back
Top