View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bob Vance Bob Vance is offline
external usenet poster
 
Posts: 4
Default Slight adjustment needed for Macro



This Macro lets me copy down every 72 cells till 5112, But it does not copy
the font or size, can I adjust it to copy everthing in the cell,

Public Sub CopySelectionEvery72UntilRow5112()
Dim i As Long
With Selection(1)
For i = .Row + 72 To 5112 Step 72
Cells(i, .Column).Value = .Value
Next i
End With
End Sub


Thanks in advance for your help....Bob Vance