Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to transfer contents of 'Selected' cell to alternate cell. | Excel Worksheet Functions | |||
Transfer cell values to another cell by selecting button. | Excel Worksheet Functions | |||
Transfer single cell information to specific cell based on user criteria | Excel Programming | |||
Transfer value to cell | Excel Programming | |||
Cell Transfer | Excel Programming |