Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Aubrey Schmidt   on Aug 27 In MS Office Category.

  
Question Answered By: Balbir Kaur    on Aug 27

There are several problems that I see:

- Formulas start with an equals sign. Your formula doesn't have one,
so you're just plugging a text string into the cell  and it will
presumably display
exactly that string.

- The "i" in your string is simply that - "i". You want to put 4, 5, 6, 7
in instead.
You will need to break the string and concatenate the value of i or -i
into it. I.e.
"=R[" & -i & "]C[4]" or "=R[-" & i & "]C[4]"

- Your example  doesn't match your explanation. C[4] off B9 is
column E, not column A. You could use C[-1] to grab the column to the
left of your formula cell, or simply C1 to grab column 1. Similarly,
your
-i based on B9 will give you rows 5, 4, 3 and 2 respectively for i = 4
to 7.

- And last ... even if all this was correct, you would plug four formulas
into
the same cell in very quick succession. So ... it will show all four
items,
but far too quickly for you to see the first three.

Share: 

 

This Question has 2 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on VB Code Corrected Solutions Or get search suggestion and latest updates.


Tagged: