View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Kirk Kirk is offline
external usenet poster
 
Posts: 41
Default cycling through columns?

I want to know if it is possible to numerically cycle through the columns.
You can do this with cells, by using range (x,y) which allows you to
reference columns and rows numerically. I want to be able to reference the
column numerically so that I can set widths based on what column number I am
in.

I want to be able to do something like this

For x = 1 to totnumofcolumnsbeingused

if x = 5 or x = 9 then
set the width of the 5th or 9th column to 15
end if

next x

is this possible? Any help would be appreciated. Thanks.

Kirk