filling the whole sheet with text or number - vba

[lezawang]

Hi
I want to fill the whole worksheet with "hello" or with a number like 1
I wrote the code below. It is only working if
x.Value = "" (clearing the sheet)

but when I type
x.Value = "hello"
or x.Value= 1

I got error message. Any idea how to fix that. Thank
+++++++++++++++

Private Sub CommandButton3_Click()
Dim x As Range
Set x = Worksheets("sheet1").Cells
x.Value = ""
End Sub

 

[jolivanes]

What does the message say?
Not enough resources?

 

[jolivanes]

Of course the next question is, if you could, what are you going to do with 16,777,216 or 14,034,141,184 times hello

 

[lezawang]

no reason. Just to practice different things. Thank you.

 

[JoeMo]

In the Immediate Window enter:

msgbox rows.Count*columns.Countlarge

and press Enter to see how many cells you are trying to fill with a value. That causes overflow.