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 strongm 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
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
189
Andrzejek
Andrzejek
Niki_S
  • Locked
  • Question
How to read an excel file using VB 6?
Replies
17
Views
321
strongm
strongm
sal21
  • Question
scraping table in web page 2
2
Replies
24
Views
2K
strongm
strongm
Niki_S
  • Locked
  • Question
How to read excel with a gap in vb 6? 1
Replies
2
Views
137
Niki_S
Niki_S
Swi
  • Locked
  • Question
Read Excel Sharepoint File
Replies
0
Views
124
Swi
Swi

Part and Inventory Search

Sponsor

Back
Top