How does one get the row number of an active cell in a non-active worksheet?

For example if I am in Sheet2 and I wish to obtain the row number of the
active cell in Sheet 1 then what instruction will get it?

I am looking for something like:
=CELL("Row", Sheet1!ActiveCell)

Jack Cannon

You don't have to worry about it. You cannot have an active cell in a non
active worksheet.



"Jack Cannon" <(E-Mail Removed)> wrote in message
news:B547DDB6-2CD4-4021-94FE-(E-Mail Removed)...
> How does one get the row number of an active cell in a non-active
> worksheet?
>
> For example if I am in Sheet2 and I wish to obtain the row number of the
> active cell in Sheet 1 then what instruction will get it?
>
> I am looking for something like:
> =CELL("Row", Sheet1!ActiveCell)
>
> Jack Cannon

Perhaps my terminology is wrong.

I am just trying to determine which cell has the focus or is highlighted and
do it from a different worksheet.


"JLGWhiz" wrote:

> You don't have to worry about it. You cannot have an active cell in a non
> active worksheet.
>
>
>
> "Jack Cannon" <(E-Mail Removed)> wrote in message
> news:B547DDB6-2CD4-4021-94FE-(E-Mail Removed)...
> > How does one get the row number of an active cell in a non-active
> > worksheet?
> >
> > For example if I am in Sheet2 and I wish to obtain the row number of the
> > active cell in Sheet 1 then what instruction will get it?
> >
> > I am looking for something like:
> > =CELL("Row", Sheet1!ActiveCell)
> >
> > Jack Cannon
>
>
>

If a sheet is not active, no cells have focus, none are active, none are
selected. You cannot use those properties on an inactive sheet. You can
use specific range references to add data, extract data copy and paste.


"Jack Cannon" <(E-Mail Removed)> wrote in message
news:4FC8C51B-842E-4970-93CF-(E-Mail Removed)...
> Perhaps my terminology is wrong.
>
> I am just trying to determine which cell has the focus or is highlighted
> and
> do it from a different worksheet.
>
>
> "JLGWhiz" wrote:
>
>> You don't have to worry about it. You cannot have an active cell in a
>> non
>> active worksheet.
>>
>>
>>
>> "Jack Cannon" <(E-Mail Removed)> wrote in message
>> news:B547DDB6-2CD4-4021-94FE-(E-Mail Removed)...
>> > How does one get the row number of an active cell in a non-active
>> > worksheet?
>> >
>> > For example if I am in Sheet2 and I wish to obtain the row number of
>> > the
>> > active cell in Sheet 1 then what instruction will get it?
>> >
>> > I am looking for something like:
>> > =CELL("Row", Sheet1!ActiveCell)
>> >
>> > Jack Cannon
>>
>>
>>