Transfer Cell Value
I'm currently using a macro: Sub copyvalue() With Sheets("Capacity") .Range("O14").Value = .Range("BM4").Value End With End Sub But I'm very interested in getting any help to upgrade this to function so that I do not have to run the macro to get the value copie from BM4 to O14. I appreciate your help in advance -- crabtree ----------------------------------------------------------------------- crabtrees's Profile: http://www.excelforum.com/member.php...fo&userid=3761 View this thread: http://www.excelforum.com/showthread.php?threadid=57277 |
Transfer Cell Value
Maybe just put this in O14:
=BM4 or =if(bm4="","",bm4) crabtrees wrote: I'm currently using a macro: Sub copyvalue() With Sheets("Capacity") Range("O14").Value = .Range("BM4").Value End With End Sub But I'm very interested in getting any help to upgrade this to a function so that I do not have to run the macro to get the value copied from BM4 to O14. I appreciate your help in advance. -- crabtrees ------------------------------------------------------------------------ crabtrees's Profile: http://www.excelforum.com/member.php...o&userid=37611 View this thread: http://www.excelforum.com/showthread...hreadid=572779 -- Dave Peterson |
All times are GMT +1. The time now is 11:06 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com