Thread: RE: How do I copy a formula from one worksheet to another?
View Single Post
  #2 (permalink)  
Old 16th April 2009, 01:10 PM
mubashir aziz mubashir aziz is offline
Junior Member
MS Office Version: MS Office 97, 2003
MS Office Skill Level: Some VBA experience


My Top Tip Count: 0

 
Join Date: Apr 2009
Location: Lahore
Posts: 28
Thanks to others: 0
Thanked 2 Times in 2 Posts
Chats: 0
Rep Power: 1
mubashir aziz is on a distinguished road
Default Re: How do I copy a formula from one worksheet to another?
------ Register to get rid of these "In Post" ads! ------


Just put ' before existing formula now copy the while cell and paste in new sheet (don't ignore to copy whole cell including ' ).

After pasting formula just move ' and your formula will be in shape but make sure that the formula will work on relevant rows and columns only .....
Reply to this post

Did you find this post helpful? Yes | No