Adding text to a cell

  • Thread starter Thread starter David
  • Start date Start date
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.
 
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 :)
 
Back
Top