View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
David David is offline
external usenet poster
 
Posts: 2
Default Adding text to a cell

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.