Is it possible to use a Macro to edit the contents of a cell? If, for example, I wanted to add something at the beginning of the text in a column of cells?
I have fond memories of being able to do this quite simply way back when (in Lotus), but even with the Relative Reference selected it ends up something like this:
Sub Edit()
'
' Edit Macro
' Macro recorded 8/26/2002 by spage
' ActiveCell.FormulaR1C1 = " Aldine ISD"
ActiveCell.Offset(1, 0).Range("A1").Select
End Sub
Just so you'll know............. I'm trying to figure out what users who are not programers (and don't want to be) can and can't do with Macros. I'm putting togeather a course on Excel Macros for our staff.
I have fond memories of being able to do this quite simply way back when (in Lotus), but even with the Relative Reference selected it ends up something like this:
Sub Edit()
'
' Edit Macro
' Macro recorded 8/26/2002 by spage
' ActiveCell.FormulaR1C1 = " Aldine ISD"
ActiveCell.Offset(1, 0).Range("A1").Select
End Sub
Just so you'll know............. I'm trying to figure out what users who are not programers (and don't want to be) can and can't do with Macros. I'm putting togeather a course on Excel Macros for our staff.