| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Insert 4 Columns If only 9 Columns
Hi
I import text from a web page then run a macro, yet on some occasions there are 4 columns missing? Example Correct Starting From A1 to O1 (15) cells are blank, This is OK. Cell P1 which as the word Result in it. Incorrect Starting From A1 to (11) K1 cells are blank, This is Not Correct. ------- 4 Columns are missing. Cell L1 which as the word Result in it. How can I check for this, and if there is only 11 blank cells insert 4 new columns before Cell L1 which as the word Result in it. And If Correct, Do Nothing Thanks in advance Dave |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I insert columns of dates in between exsisting columns of | Excel Discussion (Misc queries) | |||
| can no longer insert new columns & unhide hidden columns | Excel Worksheet Functions | |||
| unable to insert columns in excel, insert- columns (disabled) | Excel Discussion (Misc queries) | |||
| insert columns macro is putting 2 columns instead of 1 | Excel Worksheet Functions | |||
| can't insert columns between columns | Excel Discussion (Misc queries) | |||
![DaveM[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
