I need to create a macro that will insert text from a variable into column 2 of the selected row (whatever row that may be). How do I do that??
I need to create a macro that will insert text from a variable into column 2 of the selected row (whatever row that may be). How do I do that??
[vba]
Activesheet.Cells(Activecell.Row,"B").Value = myVar
[/vba]
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
Yea!!! It works!! Thank you so much. I could not figure it out!