Select table data but ONLY the cells with values

[marcvanderpeet12]

Dear all,

I want to create a macro which does the following:

- Select A5: U5
- Select all rows down (control, shift down)
- Copy

Problem is however that i cant to this because I copied an if statement till row 300 (the data in the tab is filtered from another tab which can contain 25 - 300 rows of data. So i'm looking for a way to select all rows with data (and not with formulas!)

See excel sheet attached for better insights.

Dear regards,

Marc

 

[Debraj]

Hi MaRc!

try this...

Sub SeelctSpecialCellFormulaCHR34()
  Range("A5:U5").Resize(Application.Match("", [A5:A439], False) - 1).Select
End Sub

 

[marcvanderpeet12]

Thanks Debraj!