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