Assign a Value to Another Cell

Lazaro · May 22nd, 2002, 01:40 PM

For example: Can I assign a value of 4 to cell B4 from cell A1? I don't want to type a formula into cell B4.

Damon Ostrander · May 22nd, 2002, 01:57 PM

Hi Lazaro,

Sorry to say, no. A cell formula is never allowed to modify another cell's value (or any other cell property, for that matter).

A way around this is to use a worksheet event to implement what the formula would do, plus modifying the other cell.

Lazaro · May 22nd, 2002, 02:01 PM

Thanks. I'll see what I can do.

grigorianz · Mar 14th, 2011, 05:03 AM

Quote:

Originally Posted by Lazaro

For example: Can I assign a value of 4 to cell B4 from cell A1? I don't want to type a formula into cell B4.

Yer you can. Itis simple.

May 22nd, 2002, 01:57 PM	#2
Damon Ostrander MrExcel MVP Join Date: Feb 2002 Location: Denver, Colorado USA Posts: 4,014	Hi Lazaro, Sorry to say, no. A cell formula is never allowed to modify another cell's value (or any other cell property, for that matter). A way around this is to use a worksheet event to implement what the formula would do, plus modifying the other cell. __________________ Keep Excelling. Damon VBAexpert Excel Consulting (My other life: http://damonostrander.com )

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 22nd, 2002, 01:40 PM	#1
Lazaro New Member Join Date: May 2002 Posts: 5	For example: Can I assign a value of 4 to cell B4 from cell A1? I don't want to type a formula into cell B4.

May 22nd, 2002, 02:01 PM	#3
Lazaro New Member Join Date: May 2002 Posts: 5	Thanks. I'll see what I can do.