Try to do a simple macro

[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

 

[Dan E]

Visual Basic for Applications 101
http://support.microsoft.com/default.aspx?scid=/support/excel/content/vba101/default.asp

watch out for text wrapping, if it happens you may need to
copy and paste the above link in...

Dan E

 

[Don Guillett]

try this

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