Activecell.Row


--

HTH

RP
(remove nothere from the email address if mailing direct)


"alvis" wrote in message
...
Hi i amd writing a VBA module that will produce a report
i am using and algorithm called a control beak.
when the control changes how can i determine what row i am setting on.