using ROW in a formula

C

camron107

morning,

i have a formula which uses cell "J6" for example...

as i drag down it changes to "J7" "J8" "J9" etc... etc...

however, this formula is linked to a user form, and as the user clicks 'OK' it copy's the formula into my specified cell...

however it copy's the exact contents of the formula, and it does not change the row.. so each formula down the sheet uses "J6".

i want to modify the formula so it uses "J&ROW()" for example, but i do not know how to write this into a formula; i get the #NAME? error.

any help would be appreciated... if you want me to explain this in more detail then jus reply and i wil!!

many thanks. camron
 
C

Chip Pearson

I'm not sure I understand you question completely, but I think
you want to use the INDIRECT function. E.g.,

=INDIRECT("J"&ROW())


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




message
morning,

i have a formula which uses cell "J6" for example...

as i drag down it changes to "J7" "J8" "J9" etc... etc...

however, this formula is linked to a user form, and as the user
Click to expand...
clicks 'OK' it copy's the formula into my specified cell...
however it copy's the exact contents of the formula, and it
Click to expand...
does not change the row.. so each formula down the sheet uses
"J6".
i want to modify the formula so it uses "J&ROW()" for example,
Click to expand...
but i do not know how to write this into a formula; i get the
#NAME? error.
any help would be appreciated... if you want me to explain this
Click to expand...
in more detail then jus reply and i wil!!
 
L

LoucaGreen

Try this

Istead of "J&ROW()", you should type:
="J"&ROW()

Remember that all text should be enclosed in "" and connected wit
other parts of the formula (formulas, numbers, etc) with &s.

I hope this helps

Louca
 
Top