A very easy way is to put your formula in cell c2 and then DOUBLE click the fill handle (lower right corner)
From: Prabhu Sent: Tuesday, September 20, 2011 12:26 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ *Macro Code Request* Hi Friends, Column A & B contains some values and In Column "C" i want to add A & B value. In cell "C2" i put formula as =A2+B2 Now i want to copy the formula from cell "C2" till the last cell i.e Range should be equal to column "A" Can any one help me to know the VBA code to select range as smiler to previous columns and paste the copied cell(C2). Regards, Prabhu -- ---------------------------------------------------------------------------------- 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
