Forever_EX
New Member
- Joined
- Mar 26, 2018
- Messages
- 22
I have two worksheets, "Items" and "Originals".
I run a UserForm from "Items".
I want to be able to:
I have come up with this but it just tells me what row I am on:
Thank you in advance!
I run a UserForm from "Items".
I want to be able to:
- Find the current row I am on.
- Go to that same row on "Originals".
- Copy the row, and paste the data back onto the same row in "Items".
I have come up with this but it just tells me what row I am on:
Code:
Private Sub OriginalButton_Click()
Dim CurrentItem As Long
CurrentItem = ActiveCell.row
MsgBox CurrentItem
????
????
Application.CutCopyMode = False
Worksheets("Items").Activate
Thank you in advance!
Last edited: