|
|
#14
02-01-2016, 01:58 PM
|
|||
|
|||
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%" 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Using Right and Len formulas together | PDGood | Excel | 4 | 11-20-2015 06:50 AM |
| formulas | MSA5455 | Excel | 3 | 12-19-2014 01:50 AM |
| Help with IF or ELSE Formulas | tsaladyga | Excel | 4 | 07-23-2014 09:04 AM |
| Need help with formulas please | paul_pearson | Excel | 0 | 03-20-2013 06:51 AM |
 IF Formulas
|
mizzamzz | Excel | 1 | 07-08-2010 02:32 AM |
Windows 7 64bit 
Office 2010 64bit
Threaded Mode