Repeating same number in a column

Posted by Patricia B. on January 30, 2002 7:37 AM

Could you please tell me what to do to repeat the same number in every cell of a column?

Posted by JohnG on January 30, 2002 7:41 AM

Try this
Sub Columnsame()
Worksheets("sheet1").Columns("A:A").Value = 0
End Sub

Posted by Mark W. on January 30, 2002 7:48 AM

Simply...

1. Select the cell range where the value is to
be entered.
2. After typing the value, press Control+Enter.