Columns width in a single statement line VBA

F

Fábio Coatis

Whats wrong with that?

Columns("A:E").Width = Application.Array(5, 10, 5, 10, 5)

Thanks in advance
 
G

GS

Whats wrong with that?
Columns("A:E").Width = Application.Array(5, 10, 5, 10, 5)

Thanks in advance
Click to expand...

Answer already posted here...

microsoft.public.excel.programming

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

columns width in a single vba statement 3
Consolidation Table from Different Excel Tabs with Different Format 1
Mail Merge Help 1
Finding the right style field in VBA 0
VBA - (re-) Set a Table Style 2
find oldest date with a condition 4
Two lines in one in one line - How to do 2
Two columns followed by single page-width column on same page 0

Top