Hey guys,
I hope you can help me with this. It has been a while since i have worked with VBA and I have problems with creating a macro that will remember the row and column of an activated cell in one sheet and paste it in the same row and column in a second sheet in the same file and then adding a comment. I would be very thankful if someone could give me some good tips.
Here is what I have tried:
Sub Paid_Klicken()
'
' Paid_Klicken Makro
'
'
Dim mycell As Range
Set mycell = ActiveCell.Offset(rowOffset:=0, columnOffset:=0)
ActiveCell.Copy
Sheets("Paid").Select
mycell.Select
ActiveSheet.Paste
Application.CutCopyMode = False
mycell.AddComment
End Sub
Leonie
Bookmarks