View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Kanga 85 Kanga 85 is offline
external usenet poster
 
Posts: 34
Default Formatted cells turning up in column IV

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.