Re: Delete Rows

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Ron de Bruin (rondebruin_at_kabelfoon.nl)
Date: 05/03/04 

Date: Mon, 3 May 2004 23:16:40 +0200

Hi

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

Edit>Delete..Choose Entire row 

-- 
Regards Ron de Bruin
http://www.rondebruin.nl
"kkondrat1 >" <<kkondrat1.15p7c3@excelforum-nospam.com> wrote in message news:kkondrat1.15p7c3@excelforum-nospam.com...
> 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 data
> below:
>
> name.....age...height
> .............66.....5'8
>
> i need to do this as a macro.
>
>
> ---
> Message posted from http://www.ExcelForum.com/
>

Relevant Pages

  • Re: Deleting extra rows
    ... The other problem I have is that in order to copy the entire ranges ... without leaving any data behind, I created ranges from A2 to ... Once I export my data to Excel, and run the macro, is there a way to ... only select the cells that have data in them? ...
    (microsoft.public.excel.programming)
  • Delete Rows
    ... I want to delete all rows that contain data in a set column. ... name age height ... so i would want to delete all rows that have a name leaving the data ... i need to do this as a macro. ...
    (microsoft.public.excel.misc)
  • Re: problem with military time and making calculations
    ... i tried running the macro and it didn't do anything. ... i tried leaving them in, but i got an error message. ... i then creasted the cells i needed ...
    (microsoft.public.excel.programming)
  • RE: Comparing Rows
    ... retested the macro on a test worksheet I created. ... REMOVE DUPLICATES ALL COLUMNS ... The macro went through fairly quickly and everything was A-OK. ... Excel 2003) and therefore it wouldn't matter as some cells may be blank. ...
    (microsoft.public.excel.programming)
  • Re: Cell Protection Query
    ... If you don't see the msgbox, then the macro that you added the code to isn't ... These are the cells I'm having the problem with. ... I now fully realise that Merged Cells Are the Root of All Evil! ... protection, ..., I'd try it first. ...
    (microsoft.public.excel.misc)