Copying one cell's content and pasting it in the same row and column in another sheet

[fischbroetchen]

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

[ExcelWizards]

dim myrow as integer
dim mycol as integer

myrow = activecell.row
mycol = activecell.column

Sheets("Paid").Select
Cells(myrow, mycol).value = "Your thingy"


LowTech, but will work fine.....

[JOHN H. DAVIS]

Don't know if this will help, but it copies the activecell to sheet2 in the same cell as the active cell.

Please Login or Register  to view this content.