Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Hiding columns in Excel using VB

Status
Not open for further replies.
enak

enak

Programmer
Jul 2, 2002
412
0
0
US
I am trying to hide some columns in excel using VB6. Here is what I have so far:

.Columns("F:H").Select
.Selection.EntireColumn.Hide

The first line works fine but when the spreadsheet is displayed on the screen the columns are highlighted but are not hidden.

How can I do this?

TIA
Nate
 
Sort by date Sort by votes
Status
Not open for further replies.

Similar threads

Niki_S
  • Locked
  • Question
How to insert excel sheet into sql server using vb 6?
Replies
6
Views
100
Andrzejek
Andrzejek
Niki_S
  • Locked
  • Question
How to read an excel file using VB 6?
Replies
17
Views
183
strongm
strongm
Niki_S
  • Locked
  • Question
How to read excel with a gap in vb 6? 1
Replies
2
Views
83
Niki_S
Niki_S
Swi
  • Locked
  • Question
Read Excel Sharepoint File
Replies
0
Views
63
Swi
Swi
2009luca
  • Locked
  • Question
COUNT all items in trteeview in last level 1
Replies
4
Views
136
2009luca
2009luca

Part and Inventory Search

Sponsor

Back
Top