| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
what is the code to delete row&column.
Hi All, I want to delete first row and column. When I open the excel iam havin blank row and column. please see the attachment. Regards, Amar.. +------------------------------------------------------------------- |Filename: Delete Row&Column.doc |Download: http://www.excelforum.com/attachment.php?postid=4016 +------------------------------------------------------------------- -- aredd ----------------------------------------------------------------------- areddy's Profile: http://www.excelforum.com/member.php...fo&userid=2820 View this thread: http://www.excelforum.com/showthread.php?threadid=48339 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
what is the code to delete row&column.
You can record deleting the first row and column and then open the VB editor
to see the code: Rows("1:1").Select Selection.Delete Shift:=xlUp Columns("A:A").Select Selection.Delete Shift:=xlToLeft Range("A1").Select "areddy" wrote: Hi All, I want to delete first row and column. When I open the excel iam having blank row and column. please see the attachment. Regards, Amar... +-------------------------------------------------------------------+ |Filename: Delete Row&Column.doc | |Download: http://www.excelforum.com/attachment.php?postid=4016 | +-------------------------------------------------------------------+ -- areddy ------------------------------------------------------------------------ areddy's Profile: http://www.excelforum.com/member.php...o&userid=28204 View this thread: http://www.excelforum.com/showthread...hreadid=483393 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy column header to next column, delete & delete every nth colum | New Users to Excel | |||
| How do I delete the +four didgets from a Zip Code Column? | Excel Worksheet Functions | |||
| Code help, delete rows based on column criteria | Excel Discussion (Misc queries) | |||
| Code to delete rows and column cells that have formulas in. | Excel Worksheet Functions | |||
| VBA code delete code but ask for password and unlock VBA protection | Excel Programming | |||
![areddy[_23_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
