Thread: Increase Row Height of every other line
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Crowbar via OfficeKB.com Crowbar via OfficeKB.com is offline
external usenet poster
  
Posts: 128
Default Increase Row Height of every other line
This will do everyother row


Sub RowHeight()

For x = 1 To 400

Rows(x & ":" & x).RowHeight = 37.5
x = x + 1

Next x

End Sub



--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200605/1
Reply With QuoteReply With Quote