View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Jay[_14_] Jay[_14_] is offline
external usenet poster
 
Posts: 8
Default how to select every third row

Thanks for the response

I meant to say every third column. I figured out a way.

z = 3
For p = 1 To amount
Worksheets("sheet1").Activate
Worksheets("sheet1").Columns(Z).ColumnWidth = 3.59
Z = Z + 3
Next p

Jay
-----Original Message-----
If the other rows (not every third) are not empty, you

could use F5, Special
Cells, Blanks. to select the empty cells.

--
Regards,

Juan Pablo González

"Jay" wrote in

message
...
I need to adjust the width of every third row (empty)

in a
large range. Thanks in advance

Jay



.