using ROW in a formula

[Guest]

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

 

[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

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!!

 

[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