Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding Text if Value of Cell = 0 | Excel Worksheet Functions | |||
Adding text to cell | Excel Worksheet Functions | |||
Adding hyphen to text in cell | Excel Discussion (Misc queries) | |||
Adding the cell if text is contained within | Excel Discussion (Misc queries) | |||
Adding Cell Range with Text | Excel Worksheet Functions |