Macros
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
.
|