Code to cut data and paste as values, then delete specific range of row when the cells in column D is blank

[SecretExcel_Beginner]

Hi I am a new VBA learner.

Need help for code, to cut data and paste as values, then delete specific range of row when the cells in column D is blank

Eg. I have a quotation table in my sheet (=Quote!$A$10:$AL$265).
I would like to first cut of (=Quote!$A$10:$K$260) and paste as value, afterwards, to delete the rows where in column D starting from D11-D132 there is a value in it, but between D133-D260 is blank. And I need to delete these blank row.


Can help?

 

[Fluff]

How about

Sub Convert2ValDel()
   With Range("A10:K260")
      .Value = .Value
   End With
   Range("D11:D132").SpecialCells(xlBlanks).EntireRow.Delete
End Sub

 

[SecretExcel_Beginner]

Hi I tried but it come up with an error :

Run-time error '1004':
no cells are found

It does not work

 

[Fluff]

Do you have any blank cells in D11:D132?
If so what formula have you got in that range?

 

[SecretExcel_Beginner]

Do you have any blank cells in D11:D132?
If so what formula have you got in that range?

So my quotation every column has formulas except for column D.

In this case, I want to use cell in column D where there is no formula as my specific cell to delete the blank row after i have cut and paste Column A11:A260 to column K11:K260.

I am not sure too if i provide enough information for you all to help me.

Do let me know what other information needed to build the code.

Thanks a million!!!

 

[Fluff]

If you got the error reported in post#3 then there are no blank cells in D11:D132