Activecell.row and column

[KJP0422]

I have an Excel File that contains 2 sheets. Sheet 1 name = List, Sheet 2 name = Form

I would like to set up a formula on my Sheet named Form, that references the Activecell.Row on the List Sheet

I have tried numerous ways but can't seem to remember the formula from years ago

I have used =List!Activecell.row.column1 and numerous other ways, can someone please refresh my memory.

Thank You in advance

 

[Jeffrey Mahoney]

There are formulas to get the active row. They need to be triggered by a recalc. They also cannot be tuned to just get the active row from one sheet. As in Cell D4, as soon as a recalc is complete, it updates to the current active row.

If you don't find another solution, try this VBA method. Add the code below to the List sheet module in VBA. If you have questions, please ask.

Book3
	B	C	D
2	ListRow
3	58
4			58
Form

Cell Formulas
Range	Formula
D4	D4	=CELL("row")

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
  Form.Range("ListRow").Value = Target.Row
End Sub

 

[KJP0422]

There are formulas to get the active row. They need to be triggered by a recalc. They also cannot be tuned to just get the active row from one sheet. As in Cell D4, as soon as a recalc is complete, it updates to the current active row.

If you don't find another solution, try this VBA method. Add the code below to the List sheet module in VBA. If you have questions, please ask.

Book3
	B	C	D
2	ListRow
3	58
4			58
Form

Cell Formulas
Range	Formula
D4	D4	=CELL("row")

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
  Form.Range("ListRow").Value = Target.Row
End Sub

Thanks but I am really hoping for a formula. It's a very fast paced environment and forms needed to be printed for the paperwork. Telling the users that a formula is needed let alone VBA would totally freak them out.