| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
take every other cell and put in new colume. No blank cells
Good point, thanks Gord. I have the Del_Empty_Rows() macro on a
toolbar so it's just a button click away, but it's good to remember the non-macro version. I also read your post about copy and pasting cells as links, same response :) --JP On Jan 11, 4:43*pm, Gord Dibben <gorddibbATshawDOTca wrote: JP After paste special, you could also select the column and F5SpecialBlanksOK EditDeleteEntire Rows. Gord Dibben *MS Excel MVP |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I validate an entire colume instead of a cell | Excel Worksheet Functions | |||
| Change from row to colume n colume to row | Excel Programming | |||
| Start Cell B1 then find first blank cell, insert subtotal, next non blank, then next blank, sutotal cells in between......... | Excel Programming | |||
| Copy to first Blank cell in Colum C Non blank cells still exist be | Excel Programming | |||
| How can I look up max of one colume and display the colume to the. | Excel Worksheet Functions | |||
![JP[_4_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
