Excel poisoning #2: get address of a cell

Working with VBA, need to add formulas to your sheet via cell address of course!

Address() is your function, here are some samples:

  • myRange.Address(False, False) ===> A1C2
  • myRange.Address(External:=False) ==>> $A$1$C$2
Advertisements

One Response to “Excel poisoning #2: get address of a cell”

  1. Excel poisoning #3: writing formula in cell « a developer’s breadcrumb Says:

    […] this post, better read previous about cell […]

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


%d bloggers like this: