Hi,
I am just starting to learn macros and I wrote one that appends a "-p" to a cell. How can I get this to work on all selected cells?
can someone tell me how I can run the same macro on all selected cells in a column??
Cheers,Sub MarkAsStandAlone() ' ' MarkAsStandAlone Macro ' ' Keyboard Shortcut: Ctrl+Q ' Dim cellvalue As String Dim R As String Dim C As String R = ActiveCell.Row C = ActiveCell.Column cellvalue = ActiveCell.Value ActiveCell = cellvalue & "-i" End Sub
Thanks
Bookmarks