| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Delete Rows
I think my question is too simple, because I've been searching through these threads and can't seem to find the answer. All I want to do is write into my macro the code to delete rows 1 and 2. That's it. Can someone tell me what code to use? I'm afraid I'm a little too new at designing macros. Thanks for your help! -- andysgirl8800 ------------------------------------------------------------------------ andysgirl8800's Profile: http://www.excelforum.com/member.php...o&userid=34752 View this thread: http://www.excelforum.com/showthread...hreadid=545666 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Delete Rows
Try
Rows("1:2").Delete -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "andysgirl8800" wrote in message news:andysgirl8800.28ds9a_1148590202.0129@excelfor um-nospam.com... I think my question is too simple, because I've been searching through these threads and can't seem to find the answer. All I want to do is write into my macro the code to delete rows 1 and 2. That's it. Can someone tell me what code to use? I'm afraid I'm a little too new at designing macros. Thanks for your help! -- andysgirl8800 ------------------------------------------------------------------------ andysgirl8800's Profile: http://www.excelforum.com/member.php...o&userid=34752 View this thread: http://www.excelforum.com/showthread...hreadid=545666 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Delete Rows
Rows("1:2").Delete
-- HTH Bob Phillips (remove nothere from the email address if mailing direct) "andysgirl8800" wrote in message news:andysgirl8800.28ds9a_1148590202.0129@excelfor um-nospam.com... I think my question is too simple, because I've been searching through these threads and can't seem to find the answer. All I want to do is write into my macro the code to delete rows 1 and 2. That's it. Can someone tell me what code to use? I'm afraid I'm a little too new at designing macros. Thanks for your help! -- andysgirl8800 ------------------------------------------------------------------------ andysgirl8800's Profile: http://www.excelforum.com/member.php...o&userid=34752 View this thread: http://www.excelforum.com/showthread...hreadid=545666 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Delete Rows
thank you so much! knew it had to be simple! is it just as simple to move column F to column A? -- andysgirl8800 ------------------------------------------------------------------------ andysgirl8800's Profile: http://www.excelforum.com/member.php...o&userid=34752 View this thread: http://www.excelforum.com/showthread...hreadid=545666 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Delete Rows
To overwrite the existing Column A with Column F (and F is deleted)
Columns(6).Cut Columns(1) To insert before column A and delete F Sub AAB() Columns(6).Cut Columns(1).Insert End Sub -- regards, Tom Ogilvy "andysgirl8800" wrote in message news:andysgirl8800.28du3y_1148592602.1133@excelfor um-nospam.com... thank you so much! knew it had to be simple! is it just as simple to move column F to column A? -- andysgirl8800 ------------------------------------------------------------------------ andysgirl8800's Profile: http://www.excelforum.com/member.php...o&userid=34752 View this thread: http://www.excelforum.com/showthread...hreadid=545666 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hpw do I delete multiple empty rows found between filled rows? | Excel Worksheet Functions | |||
| Cut filtered rows, paste into next empty row of new sheet, and delete cut rows | Excel Worksheet Functions | |||
| Delete rows with numeric values, leave rows with text | Excel Programming | |||
| How to delete rows when List toolbar's "delete" isnt highlighted? | Excel Worksheet Functions | |||
| Delete every 3rd row, then delete rows 2-7, move info f/every 2nd row up one to the end and delete the row below | Excel Programming | |||
![andysgirl8800[_5_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
