What is "it" and what happened(or didn't) when you ran the macro or took the
manual method?


Gord

On Fri, 11 Feb 2005 20:55:53 -0800,
wrote:

It didn't work.

What else can I try?

Don

-----Original Message-----
One of these days I'll get out of the habit of selecting
first <bg


"Gord Dibben" <gorddibbATshawDOTca wrote in message
. ..
Don

Sub round()
For Each cel In Range("a1:a3000")
cel.Value = "Round"
Next
End Sub

There has to more to this<g

You can do the same thing manually.

Type A1:A3000 in the Name Box and ENTER

Type Round in A1 and hit CTRL + ENTER


Gord Dibben Excel MVP

On Fri, 11 Feb 2005 17:14:06 -0800, "Don"
wrote:

How do I create a macro that will type the word "Round"
in cells A1 thru A3000 one at a time?

Thanks,

Don



.