Thread: [Solved] VBA formulas
View Single Post
 
Old 02-01-2016, 01:58 PM
zhead zhead is offline Windows 7 64bit Office 2010 64bit
Advanced Beginner
  
Join Date: Mar 2015
Location: Texas
Posts: 32
zhead is on a distinguished road
Default
Sorry for the delay but work got me humping. Thanks for everything.
i have another question. This code works great but when i click on the cell on the worksheet the formula bar shows the formula. and when i copy this cell to another sheet the formula copies instead of the value.

Range("AC3").Formula = ("=IFERROR(AD2/Y2,0)")
Range("AC3").Select
Selection.NumberFormat = "0%"
Reply With Quote