Recent content by Dhamo

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

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.

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?

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...

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

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...

Congratulations Luke. Love your techniques..!!

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

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))

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...

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...

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

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

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.

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