Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
If I remove a Column:
Columns ("B:B").Delete Shift:=xlToLeft, I find that column IV (the last column in the spreadsheet) turns up with a formatted cell (IV3) with a Border.Linestyle. If I then try to insert a Column: Columns ("B:B").Insert Shift:=xlToRight, I get the error message "To prevent possible loss of Data Microsoft Excel cannot shift nonblank cells off the worksheet...." I can obviously go to Range "IV3" and clear the formatting, but that seems tedious. How do I ensure that I get a blank column IV when I delete a column elsewhere in a spreadsheet, and why does this formatted column appear when I might have expected a totally blank new column? Thanks for any help/advice. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
column formatted to general - cells keep changing to date? | New Users to Excel | |||
Turning a row's contents into a column of entries | New Users to Excel | |||
Turning a row into a column? While importing? | Excel Discussion (Misc queries) | |||
Converting 'General' formatted cells to Text formatted cell using. | Excel Worksheet Functions | |||
VB - turning cells specified colours | Excel Programming |