Adding text to a cell

D

David

I have used Word VBA a lot but am new to Excel VBA. I am
trying to add a string ("Verify") to a cell that already
contains text. I tried to create a variable for the
existing text and then add the new string in front of the
variable, but it doesn't work. What should I have written?

Dim variable1
Worksheets("Sheet1").Activate
ActiveCell.FormulaR1C1 = variable1
ActiveCell.Value = "Verify" & variable1
ActiveCell.Offset(1, 0).Activate


Thanks for any help you can give.
 
D

David

That was easy. Thanks Tom--very fast response. This simple
code (plus an "activecell.offset" command line) will be
used by engineers to save hours of time (and thus help
improve efficiency and help keep inflation down--or maybe
just give them more time to browse the internet :)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top