General Discussion

From the totally simple like pseudo code- Wingmate, Can you tell me how to generate a VB script for Excel to append or prefix multiple cells at once?
Sub AddTextToCells()
Dim cell As Range
Dim textToAdd As String
Dim position As String

textToAdd = InputBo "Enter text to add:&quot
position = InputBo "Enter 'P' for Prefix or 'S' for Suffix:&quot

For Each cell In Selection
If cell.Value "" Then
If UCase(position) = "P" Then
cell.Value = textToAdd & cell.Value
ElseIf UCase(position) = "S" Then
cell.Value = cell.Value & textToAdd
End If
End If
Next cell
End Sub

This will allow you to append or prefix a selection of cells that are already populated in Excel.

To much more complicated things like entire applications for something mission critical written in ADA. It's pretty remarkable right now and people a lot smarter than me are already doing a lot of work with it.