TRUE instead of a number

[braindiesel]

I am working on a large document.
In the macro, this line of code

Sheets("backstage").Range("adjStaffCurRow").Value = Selection.Row

should yield the row number in my cell named adjStaffCurRow

Instead, I get "TRUE"

I have had this issue in other areas as well, using a list index where instead of saying the correct row number, I get TRUE as a result.

This is using Excel 2007.

Am I missing something? I have asked this question before and still have no solution. I would really appreciate any assistance in correcting this error.

Thanks in advance,
Glen

 

[CharlesChuckieCharles]

Probably better to give more info

 

[shg]

That is a logical statement. If you want the row,

myRow = Worksheets("backstage").Range("adjStaffCurRow").Row

 

[braindiesel]

I am still getting stuck on this one.

I want to be in a cell on Sheet X
I want the vba to identify the row number, let's assume it is 16
I want a named cell on my backstage tab to then have the value of 16

Here is the code I am using to do this
Sheets("backstage").Range("adjStaffCurRow").Value = Selection.Row

Instead of a 16, sometimes it gives the number, other times it says TRUE

I clearContents of my adjStaffCurRow elsewhere so that is is always starting from empty.

This suggested code works to give me temporary storage
myRow = Worksheets("backstage").Range("adjStaffCurRow").Row
because another macro may or may not need to go to cell A16 in this case
range("A" & Range("adjStaffCurRow").value)

What am I missing here?
Please help

 

[CharlesChuckieCharles]

This updates a named range called Boo in the current workbook with whatever is in the activecell ( which is whatever cell you've highlighted )

Sub UpdateNamedRangeFromActiveCell()
 
ActiveWorkbook.Names("Boo").RefersToRange = ActiveCell.Value
End Sub

so highlight a cell with data and run this macro

for row number

ActiveWorkbook.Names("Boo").RefersToRange = ActiveCell.Row

 

[braindiesel]

This just gives me the cell contents. I need to store the active row number.

When I change it to refers to activecell.row, I get TRUE again

I need the number.

 

[CharlesChuckieCharles]

if gives me the number for row and whatevers in the cell for Value


Did you copy the code? or just copy the Activecell.row bit

 

[Ruddles]

Sheets("backstage").Range("adjStaffCurRow").Value = Selection.Row
should yield the row number in my cell named adjStaffCurRow
Instead, I get "TRUE"

I regret to report that when I try this here (Excel 2007), I always get the row number of the selected range exactly where I (and you) were expecting it - never a value of TRUE (or FALSE for that matter).

What happens if you set this scenario up in a completely new workbook?

 

[braindiesel]

The issue seems to be that I get the number one time, but if I do the same macro again, I get TRUE.

This creates a debug error.
I stop and start over and it works fine.

I cannot have clients doing this. Any ideas?

 

[braindiesel]

Charles, I copied both the active cell line and

ActiveWorkbook.Names("Boo").RefersToRange = ActiveCell.Row

The code works every second time.

I haven't tried it in a new workbook, but this workbook contains over 30 sheets and about 40 pages of code. I really don't want to start over