Selection.FormulaArray = "=RC[-4]:R[" & z & "]C[-4]&RC[-3]:R[" & z & "]C[-3]&RC[-2]:R[" & z & "]C[-2]"
On Jun 19, 4:29 pm, hanumant shinde <arsfan2...@yahoo.co.in> wrote: > 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