Try to do a simple macro

T

Tom

I have not used a macro in excel for many years. I am
rying to do a simple macro to add text to a cell and then
go to the next cell and add the same information to it. I
have tried recording it several different ways and it does
not work. Is there a basic macro web site to learn how to
record macros that work?

Thanks
 
D

Don Guillett

try this

Sub addinfo()
activecell.Resize(2, 1) = _
InputBox("enter whatever") '"hi"
End Sub
 
Top