Delete Rows

K

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
 
R

Ron de Bruin

Hi

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

Edit>Delete..Choose Entire row
 
R

Ron de Bruin

Hi
name age height
john...15....6'2
kevin...67...5'4
66...5'8
Click to expand...

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