Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I need macros to perform two operations on the following example.
1. I need to delete any Accounts in columns A,E and I that begin with R. 2. I need a macro to clear the contents of the entire workbook starting at row 3. A B C D E F G H I J K 1 Account Long Short Account Long Short Account Long Short 2 3 PA037 4 PA037 4 CR237 7 4 Q1024 4 Q1024 4 PA037 4 4 Q1024 4 Q1024 4 HI012 8 5 Q2050 4 Q2050 4 R2009 5 6 Q2450 1 Q2450 1 R8912 6 7 R0000 33 R0000 33 8 R0924 4 R0924 4 9 5032 33 5032 33 10 10375 20 10375 20 11 29280 1 29280 1 12 39124 2 39124 15 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Macros: can you copy macros from one doc to another? | Excel Discussion (Misc queries) | |||
Excel 2007 macros - how to merge 5 macros together into one | Excel Discussion (Misc queries) | |||
Macros warning always shows up, even if all macros removed | Excel Discussion (Misc queries) | |||
Macros - copying macros from one computer to another | Excel Discussion (Misc queries) | |||
Training: More on how to use macros in Excel: Recording Macros | Excel Worksheet Functions |