Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
RL RL is offline
external usenet poster
 
Posts: 22
Default Select and delete entire row Excel VBA macro

Hi,
I cannot find out how to select and delete the entire row - row number
varies but contains the active cell. Anyone who can help?
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 10,124
Default Select and delete entire row Excel VBA macro

activecell.EntireRow.delete

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"RL" wrote in message
...
Hi,
I cannot find out how to select and delete the entire row - row number
varies but contains the active cell. Anyone who can help?


  #3   Report Post  
Posted to microsoft.public.excel.programming
RL RL is offline
external usenet poster
 
Posts: 22
Default Select and delete entire row Excel VBA macro

Blush - tried that with a spelling error
Thanks

"Don Guillett" wrote:

activecell.EntireRow.delete

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"RL" wrote in message
...
Hi,
I cannot find out how to select and delete the entire row - row number
varies but contains the active cell. Anyone who can help?



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro to copy values then delete row for entire sheet Pyrotoy New Users to Excel 18 December 9th 08 12:43 AM
why does this macro select the entire worksheet when run? Dave F Excel Discussion (Misc queries) 6 March 1st 07 01:19 PM
Macro - delete entire row which contain a specific text Dileep Chandran Excel Worksheet Functions 1 December 6th 06 01:08 PM
Help! with Macro - delete entire row Rashid[_2_] Excel Programming 3 March 4th 06 09:14 PM
macro to delete entire rows when column A is blank ...a quick macro vikram Excel Programming 4 May 3rd 04 08:45 PM


All times are GMT +1. The time now is 05:47 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"