Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel VBA - delete hidden column in mergence status
I want to delete the hidden columns with following scripts
Sub Macro7() For i = 65 To 80 temp = Chr(i) & ":" & Chr(i) Columns(temp).Select bTEST = Selection.EntireColumn.Hidden If bTEST = True Then Selection.Delete Shift:=xlToLeft i = i - 1 End If Next End Sub It can work when no mergence. But if D3:H3 cells are merged, and Colum E is hidden, the loop goes to Columns("E:E"), the property feeds back i still "False", in that case, the hidden column E can't be delet correctly. Pls help out, ^_^ seang -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel VBA - delete hidden column in mergence status
Don't use merged cells ... that's the best advice I can give you.
In this particular case, you can probably solve your problem by skipping the Select step and using Columns(temp) instead of Selection in the next two steps. -- Vasant "seangu " wrote in message ... I want to delete the hidden columns with following scripts Sub Macro7() For i = 65 To 80 temp = Chr(i) & ":" & Chr(i) Columns(temp).Select bTEST = Selection.EntireColumn.Hidden If bTEST = True Then Selection.Delete Shift:=xlToLeft i = i - 1 End If Next End Sub It can work when no mergence. But if D3:H3 cells are merged, and Column E is hidden, the loop goes to Columns("E:E"), the property feeds back is still "False", in that case, the hidden column E can't be delete correctly. Pls help out, ^_^ seangu --- Message posted from http://www.ExcelForum.com/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel VBA - delete hidden column in mergence status
thank you!
As you said, the problem is the selection. Right now, i have change to column(temp).delete, it's working now. --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Checking Column Status on closing excel - Macro Needed | Excel Discussion (Misc queries) | |||
2007 Worksheet, Hidden Columns, .CSV Format Saves Hidden Column Da | Excel Discussion (Misc queries) | |||
How can I delete Excel rows that I've hidden without restoring the | Excel Discussion (Misc queries) | |||
How do I delete hidden character in Excel? | Excel Discussion (Misc queries) | |||
Check status row (hidden or visible)? | Excel Programming |