placing a value in a cell

kluitna · Apr 5th, 2002, 01:55 PM

This seems like it should be very simple. WhatI am trying to do is in a macro take a value from one cell add to it and place it in another cell.

How is this done? anyone out there know?

Thanks in advance
Paul

Al Chara · Apr 5th, 2002, 02:10 PM

Try the following:

[a1].Value = [a2].Value + [a1].Value

It takes the value in Cell A2 and adds it to the value in cell A1 and puts the result in A1.

kluitna · Apr 5th, 2002, 03:24 PM

Thanks allot Al, you have been saving my bacon today. Really appreciate it.

Apr 5th, 2002, 02:10 PM	#2
Al Chara MrExcel MVP Join Date: Feb 2002 Location: Monterrey, Mexico Posts: 1,433	Try the following: [a1].Value = [a2].Value + [a1].Value It takes the value in Cell A2 and adds it to the value in cell A1 and puts the result in A1. __________________ Kind regards, Al Chara

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

Apr 5th, 2002, 01:55 PM	#1
kluitna Board Regular Join Date: Mar 2002 Posts: 75	This seems like it should be very simple. WhatI am trying to do is in a macro take a value from one cell add to it and place it in another cell. How is this done? anyone out there know? Thanks in advance Paul

Apr 5th, 2002, 03:24 PM	#3
kluitna Board Regular Join Date: Mar 2002 Posts: 75	Thanks allot Al, you have been saving my bacon today. Really appreciate it.