Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #5  
Old 10-12-2014, 07:38 PM
Sgt Rock Sgt Rock is offline Show result of formula as a value in another cell Windows 8 Show result of formula as a value in another cell Office 2010 64bit
Novice
 
Join Date: Nov 2013
Location: Dallas, Texas
Posts: 16
Sgt Rock is on a distinguished road
Default

If you still want to copy as originally asked in your question just write a lil macro
E.G.
Sub CopyValue()
Range("G5").Select
Selection.Copy
Range("D8").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
End Sub
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel formula from looking the base date and convert into desire result PRADEEPB270 Excel 1 02-17-2013 03:11 AM
Convert Formula Result to Static Text MYGS Excel 16 01-21-2013 08:18 AM
Show result of formula as a value in another cell If formula result is negative then display text oxicottin Excel 3 12-03-2012 02:12 AM
IF formula returns wrong result mashley Excel 3 09-07-2012 07:03 AM
Can I create a formula that will show result in the same cell and let me copy it down CranstC Excel 1 02-11-2012 01:29 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:15 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft