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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding text to a cell
ActiveCell.Value = "Verify " & activcell.Value
-- Regards, Tom Ogilvy "David" wrote in message ... 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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding text to a cell
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 :) |
Reply |
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 |