How do I set a value in MS Excel?

How do I set a value in a MS Excel cell from inside my VB Macro?

Re: How do I set a value in MS Excel?

Moved from FAQ forum

Re: How do I set a value in MS Excel?

Welcome to the Forums :wave:

The answer to your question depends on how you are referring to the cell in question. Can you elaborate a little more on How you are determining which cell you need to change?

Also if you could post the code you have so far, that would help as well.

The most basic way is to directly refer to the cell as a range
VB Code:
Workbooks("BookName").Worksheets("SheetName").Range("A1").Value = "Your Value"