Hello, This one works for me :
Selection.FormulaArray = _ "=RC[-4]:R[" & Z & "]C[-4]&RC[-3]:R[" & Z & "]C[-3]&RC[-2]:R[" & Z & "]C[-2]" Daniel -----Message d'origine----- De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De la part de hanumant shinde Envoyé : dimanche 19 juin 2011 13:30 À : Excel Group Objet : $$Excel-Macros$$ Use of Variabe in Array formula ---- urgent Hi Friends, I really need urgent help. i want to deliver smthing by tomorrow and i stuck here. Selection.FormulaArray = "=RC[-4]:R[46]C[-4]&RC[-3]:R[46]C[-3]&RC[-2]:R[46]C[-2]" I have this formula and instead of 46th row i want to use Variable "Z". i tried below things but its not working ' Selection.FormulaArray = _ ' "=RC[-4]:R[" & Z & "]C[-4]&RC[-3]:R[ " & Z & " ]C[-3]&RC[-2]:R[" & Z & "]C[-2]" ' Selection.FormulaArray = _ ' "=RC[-4]:R[Z]C[-4]&RC[-3]:R[Z]C[-3]&RC[-2]:R[Z]C[-2]" -- ---------------------------------------------------------------------------- ------ Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel