Address of a cell left of a given cell.

  • Thread starter Thread starter Swiatkowski Peter
  • Start date Start date
S

Swiatkowski Peter

What is the syntax of an address of cell immediately to the left of a given
cell ?

Can you please also write syntax of an address of cell immediately to the
right of a given cell. Perhaps that will help me understand and maybe even
figure out an address of a cell immediately below or above a given cell.

Also, can a cell that is more than one cell away also be addressed in a
similar format ?



Peter
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Re : Excel Data>Sort... Tracking of Cell Addresses Used in Formulae 1
is Retrieving a Cell address from a cell containing a SUMPRODUCTformula a problem ? 5
(Advanced Excel) Figuring out a formula of continuous progressiontrying to create 19 Formulas into O 5
Mutiply in a range of cells ? 1
Moving a bunch of data 1
Inserting cells (shift cells right) using macro 0
Locate highlighted cell?? 5
Need to count cells in Column1 where each cell's row also hasspecified value in Column2 1

Back
Top