Delete Rows

[kkondrat1]

Hello,

I want to delete all rows that contain data in a set column.

for example:

name age height
john...15....6'2
kevin...67...5'4
66...5'8

so i would want to delete all rows that have a name leaving the dat
below:

name.....age...height
..............66.....5'8

i need to do this as a macro

 

[Ron de Bruin]

Hi

Select the cells in column A
F5
Special
Constants (with only text checked)
Ok

Edit>Delete..Choose Entire row

 

[kkondrat1]

that doesn't work.......

I need to delete all the rows that contain data

 

[Ron de Bruin]

Hi

name age height
john...15....6'2
kevin...67...5'4
66...5'8

I thought 66 is also in Column A
Do the same and check constants and don't uncheck the three items