| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to delete cells ?
undefined::undefined:: Hi All, I would like to do the following column deletions programatically using VBA. In a Test.Xls file i have 5 columns and 8 rows. In the 5th column i don't have any data in last 2 rows i,e 7th and 8th rows. I need to delete the first 6 rows of Column A by shift cells left, so that the whole data in the Test.Xls will be accomodated into 4 columns and 8 rows. If  Then, open an xxx.xls and then give me a solution.Thanks in advance :( suseee -- susee ------------------------------------------------------------------------ susee's Profile: http://www.excelforum.com/member.php...o&userid=24510 View this thread: http://www.excelforum.com/showthread...hreadid=381041 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| delete cells column. Delete empty cells | Excel Worksheet Functions | |||
| how can I delete cells containing text within a range of cells | Excel Discussion (Misc queries) | |||
| how do I merge cells into one then delete the original cells? | Excel Worksheet Functions | |||
| How to delete all the blanc cells in a worksheet and shift cells l | Excel Discussion (Misc queries) | |||
| Delete specific cells contents in a row with some locked cells in the same row | Excel Programming | |||
Threaded Mode
