Reputation: 15
My Private Sub Worksheet_Calculate() runs when I place it into Sheet1(Sheet1) as a part of VBAProject (Book1) but it doesn't when I place it into Sheet1(Sheet1) as a part of VBAProject (PERSONAL.XLSB).
Why is that the case? What shall I do to make it run?
Thanks in advance!
Private Sub Worksheet_Calculate()
Dim LastRow As Long
LastRow = Cells(Rows.Count, 2).End(xlUp).Row
Cells(LastRow, 2).Offset(1, 0) = Cells(2, 1)
End Sub
Upvotes: 0
Views: 69
Reputation: 3068
PERSONAL.XLSB is a hidden workbook that doesn't usually have formulas or anything else on its sheets. No formulas so nothing to calculate and the event never fires.
Upvotes: 1