Microsoft Office Forums - View Single Post - [Solved] specifying a cell value from another cell and a constant

Thread: [Solved] specifying a cell value from another cell and a constant

View Single Post

Old

08-25-2014, 10:24 PM

excelledsoftware excelledsoftware is offline

excelledsoftware is offline

excelledsoftware uses Windows 7 64bit

Windows 7 64bit excelledsoftware uses Office 2003

excelledsoftware uses Office 2003

Office 2003

IT Specialist

Join Date: Jan 2012

Location: Utah

Posts: 455

excelledsoftware will become famous soon enough

Default

If you are putting a sum into a cell then I think all that's missing is your equals sign.

Code:

ActiveSheet.Range("$A$" & i).Value = "=$R$42" & "-140.5"

Reply With Quote