Activecell.row and column

KJP0422

New Member
Joined
Apr 28, 2016
Messages
23
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
 
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
BCD
2ListRow
358
458
Form
Cell Formulas
RangeFormula
D4D4=CELL("row")


VBA Code:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
  Form.Range("ListRow").Value = Target.Row
End Sub
 
Upvote 0
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
BCD
2ListRow
358
458
Form
Cell Formulas
RangeFormula
D4D4=CELL("row")


VBA Code:
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.
 
Upvote 0

Forum statistics

Threads
1,226,772
Messages
6,192,928
Members
453,767
Latest member
922aloose

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top