Excel poisoning #3: writing formula in cell

Before this post, better read previous about cell address.

Here are a sample on writing formula in a cell:

myRange.Cells(2, 2).Formula = “=SUM(A1:A4)”

More: localization may get you some headache, so True/False better be written in english, and parameters my be “,” separated, not “;” . ;)

source: Office Space: Tips and Tricks for Scripting Microsoft Office Applications

About these ads

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s


Follow

Get every new post delivered to your Inbox.

%d bloggers like this: