Hey guys,
I have the following code that copies a cell from the active worksheet to the mentioned one
Is there a way to add a confirmation msgbox (Yes/No) at the beginning that mentions the name of the active workbook and to where you are moving the information?
Thanks a lot!!
I have the following code that copies a cell from the active worksheet to the mentioned one
VBA Code:
inarr = Range("A1:J57")
With Workbooks("Workbook1.xlsx").Worksheets("Test")
loLastRow = .Cells(Rows.Count, 1).End(xlUp).Row + 1
.Range("A" & loLastRow) = inarr(43, 7)
End With
Is there a way to add a confirmation msgbox (Yes/No) at the beginning that mentions the name of the active workbook and to where you are moving the information?
Thanks a lot!!