Making a table

[Kepler]

Hi,

Given some results, I want to build a table in Excel. How can I do
this? The first line, from A1:J1 will have a content in each cell;
A2:J2, A3:J3, etc...will have similar formula contents. The process
must be conducted by an IF statement ( otherwise it would fill the
entire sheet).

Can anyone help me out?

Kind regards,

Kepler

 

[Don Guillett]

Sometimes the macro recorder can be your friend. To show you, I just
recorded this
Sub Macro3()
'
' Macro3 Macro
' Macro recorded 12/10/2005 by Don Guillett
'

'
Range("H1:I1").Select
Selection.AutoFill Destination:=Range("H1:I10"), Type:=xlFillDefault
Range("H1:I10").Select
End Sub

which may then be refined by removing selections
Sub filldown()
Range("H1:I1").AutoFill Range("H1:I10")
End Sub

You would have to give more info on what determines the last row to fill to
such as

lastrow=cells(rows.count,"a").end(xlup).row
Range("H1:I1").AutoFill Range("H1:I" & lastrow)