Forum Discussion
dlowrey2120
Jun 20, 2023Copper Contributor
Excel VBA - Write Function() into cell using a variable for row number?
Hello, thanks for looking. I have a function GetSomething() that I want to write into a cell using VBA. The cell is found by using a variable "lastrow", representing the last row number + 1 to obtai...
peiyezhu
Jun 20, 2023Bronze Contributor
ActiveSheet.Cells(lastrow, "D").Formula = "=GetSomething("C" & lastrow & ")"