| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Row() function returns wrong row and more..
Using 2003 w/SP2, all current updates, nothing disabled and all but Euro
Currency Tools loaded. Cell A10 has 'kim' in it. New workbook with "=row(kim)" in D2 returns #NAME?. Existing workbook returns "11". (I move text and the row changes, but always one higher than actual row. I've verified no hidden rows on worksheet I can deal with the "one row off" thing with code but can't figure out the difference in files. Any clue where I'm failing to understand what's happening? Thanks, Kim |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Row() function returns wrong row and more..
Hi Kim,
If you select A11, you'll see "Kim" in the Name box (right above A1). This is a defined name, which you can use instead of a cell address. The ROW() function needs a Range reference, either a cell address(ses) or a defined name. -- Kind regards, Niek Otten Microsoft MVP - Excel "Kim" wrote in message ... | Using 2003 w/SP2, all current updates, nothing disabled and all but Euro | Currency Tools loaded. | | Cell A10 has 'kim' in it. New workbook with "=row(kim)" in D2 returns | #NAME?. Existing workbook returns "11". (I move text and the row changes, | but always one higher than actual row. I've verified no hidden rows on | worksheet | | I can deal with the "one row off" thing with code but can't figure out the | difference in files. | | Any clue where I'm failing to understand what's happening? | | Thanks, | | Kim |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Row() function returns wrong row and more..
Hi Niek,
I think I got one issue solved. ToolsOptionsCalculations select "Accept Labels in Formulas" lets me put "kim" into row(). It still returns one row higher than actual text but I'm closing in........... Thanks for you help! Kim "Niek Otten" wrote: Hi Kim, If you select A11, you'll see "Kim" in the Name box (right above A1). This is a defined name, which you can use instead of a cell address. The ROW() function needs a Range reference, either a cell address(ses) or a defined name. -- Kind regards, Niek Otten Microsoft MVP - Excel "Kim" wrote in message ... | Using 2003 w/SP2, all current updates, nothing disabled and all but Euro | Currency Tools loaded. | | Cell A10 has 'kim' in it. New workbook with "=row(kim)" in D2 returns | #NAME?. Existing workbook returns "11". (I move text and the row changes, | but always one higher than actual row. I've verified no hidden rows on | worksheet | | I can deal with the "one row off" thing with code but can't figure out the | difference in files. | | Any clue where I'm failing to understand what's happening? | | Thanks, | | Kim |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Row() function returns wrong row and more..
Go to,
<Insert <Name <Define And see if there's a "Kim" defined there. If yes, click on it and see what's in the "Refers To" box. -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "Kim" wrote in message ... Hi Niek, I think I got one issue solved. ToolsOptionsCalculations select "Accept Labels in Formulas" lets me put "kim" into row(). It still returns one row higher than actual text but I'm closing in........... Thanks for you help! Kim "Niek Otten" wrote: Hi Kim, If you select A11, you'll see "Kim" in the Name box (right above A1). This is a defined name, which you can use instead of a cell address. The ROW() function needs a Range reference, either a cell address(ses) or a defined name. -- Kind regards, Niek Otten Microsoft MVP - Excel "Kim" wrote in message ... | Using 2003 w/SP2, all current updates, nothing disabled and all but Euro | Currency Tools loaded. | | Cell A10 has 'kim' in it. New workbook with "=row(kim)" in D2 returns | #NAME?. Existing workbook returns "11". (I move text and the row changes, | but always one higher than actual row. I've verified no hidden rows on | worksheet | | I can deal with the "one row off" thing with code but can't figure out the | difference in files. | | Any clue where I'm failing to understand what's happening? | | Thanks, | | Kim |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Row() function returns wrong row and more..
RD,
New workbook/worksheet. Sheet1. No names -- no nothing in fact except for my test entries. Kim "RagDyeR" wrote: Go to, <Insert <Name <Define And see if there's a "Kim" defined there. If yes, click on it and see what's in the "Refers To" box. -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "Kim" wrote in message ... Hi Niek, I think I got one issue solved. ToolsOptionsCalculations select "Accept Labels in Formulas" lets me put "kim" into row(). It still returns one row higher than actual text but I'm closing in........... Thanks for you help! Kim "Niek Otten" wrote: Hi Kim, If you select A11, you'll see "Kim" in the Name box (right above A1). This is a defined name, which you can use instead of a cell address. The ROW() function needs a Range reference, either a cell address(ses) or a defined name. -- Kind regards, Niek Otten Microsoft MVP - Excel "Kim" wrote in message ... | Using 2003 w/SP2, all current updates, nothing disabled and all but Euro | Currency Tools loaded. | | Cell A10 has 'kim' in it. New workbook with "=row(kim)" in D2 returns | #NAME?. Existing workbook returns "11". (I move text and the row changes, | but always one higher than actual row. I've verified no hidden rows on | worksheet | | I can deal with the "one row off" thing with code but can't figure out the | difference in files. | | Any clue where I'm failing to understand what's happening? | | Thanks, | | Kim |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Row() function returns wrong row and more..
I'm talking about the sheet (existing) where you get a return of 11 when you
enter =row(kim) in D2! -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Kim" wrote in message ... RD, New workbook/worksheet. Sheet1. No names -- no nothing in fact except for my test entries. Kim "RagDyeR" wrote: Go to, <Insert <Name <Define And see if there's a "Kim" defined there. If yes, click on it and see what's in the "Refers To" box. -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "Kim" wrote in message ... Hi Niek, I think I got one issue solved. ToolsOptionsCalculations select "Accept Labels in Formulas" lets me put "kim" into row(). It still returns one row higher than actual text but I'm closing in........... Thanks for you help! Kim "Niek Otten" wrote: Hi Kim, If you select A11, you'll see "Kim" in the Name box (right above A1). This is a defined name, which you can use instead of a cell address. The ROW() function needs a Range reference, either a cell address(ses) or a defined name. -- Kind regards, Niek Otten Microsoft MVP - Excel "Kim" wrote in message ... | Using 2003 w/SP2, all current updates, nothing disabled and all but Euro | Currency Tools loaded. | | Cell A10 has 'kim' in it. New workbook with "=row(kim)" in D2 returns | #NAME?. Existing workbook returns "11". (I move text and the row changes, | but always one higher than actual row. I've verified no hidden rows on | worksheet | | I can deal with the "one row off" thing with code but can't figure out the | difference in files. | | Any clue where I'm failing to understand what's happening? | | Thanks, | | Kim |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
