What does ActiveCell value mean in VBA?

How do I insert an active cell row in VBA?

I am writing an excel macro to copy a section of an active cell row and insert it into a different sheet.

I can find plenty of examples on how to insert a row, but none that insert an active cell row.

My code looks like this: For Each myRow In Cells(rows.Count).End(xlUp).Offset(1).Rows
With Sheets("Output"). .Range("A" & lastRow.Row).Value = .Range("A" & lastRow.Row).Value
.Range("B" & lastRow.Row).Range("C" & lastRow.Row).Range("D" & lastRow.Row).Range("E" & lastRow.Row).Value
End With. Next. I tried wrapping the relevant lines with WorksheetFunction, but it won't let me. Try this: Sub Test(). Dim wsOutput As Worksheet. Dim myRow As Range. Set wsOutput = ActiveSheet. For Each myRow In Cells(rows.Count).End(xlUp).Offset(1).Rows
wsOutput.Range("A" & lastRow.Row).Value = wsOutput.Range("A" & lastRow.Row).Value
wsOutput.Range("B" & lastRow.Row).

What does ActiveCell value mean in VBA?

I have a very basic VBA function that is supposed to calculate the average of several cells.

The input for this function is only a cell with the value ActiveCell. What does the value ActiveCell have to do with the function? Is it simply the cell that I am trying to calculate the average of?
Function CalculateMean(myrange As Range) As Double. Dim mean As Double. mean = Application.WorksheetFunction.Average(myrange)
CalculateMean = mean. End Function. I think this should be a comment, but I can't comment :(. Yes it's exactly what you think. The ActiveCell refers to the cell which is currently being referenced. So if your code is referring to the cell "C1" then the value of "ActiveCell" will refer to that same cell "C1". If you are referring to the cell C2 then the value of "ActiveCell" will reference cell C2.