| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using a macro to delete last 4 rows and last 2 columns which vary
Shirley,
Go to record a macro as normal, saving to Personal.xls, but as soon as the record starts, stop it. Then goto menu ToolsMacroMacros..., find the macro, Edit and paste that code over it. -- HTH RP (remove nothere from the email address if mailing direct) "Shirley Munro" wrote in message news:Shirley.Munro.1uoo6d_1125583528.3199@excelfor um-nospam.com... The code Bob has sent me works just fine but I am not sure how to record this using the usual Tools, Macro, Record New Macro and making it available in the Personal Macro Workbook Shirley -- Shirley Munro ------------------------------------------------------------------------ Shirley Munro's Profile: http://www.excelforum.com/member.php...nfo&userid=836 View this thread: http://www.excelforum.com/showthread...hreadid=401070 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Delete rows with more or less than 7 columns | New Users to Excel | |||
| Sum of columns that vary in position | Excel Worksheet Functions | |||
| Delete columns or rows | Excel Worksheet Functions | |||
| subtotalling - # of columns vary | Excel Programming | |||
| subtotalling where # of columns vary | Excel Programming | |||
![Bob Phillips[_6_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
