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]

Open a new workbook

does it work every time in a new workbook

If so

you probably have some code triggered on selection change or cell change or workbook change doing something else to the named range

 

[Ruddles]

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

No, not start again - I meant just to satisfy yourself that the code works as you'd expect it to. It works every time for me, not just every second time.

You don't have a Worksheet_Change event which is selecting a different cell as it executes, by any chance?

 

[CharlesChuckieCharles]

your original code, modified for my sheet

ActiveWorkbook.Sheets("Sheet3").Range("Boo").Value = Selection.Row

works everytime too

 

[jim may]

Sub Foo()
CurrRow = ActiveCell.Row
Range("MyRowNum").Value = CurrRow  'Name MyRowNum previously assigned to Cell of choice
End Sub