reference a cell - RC Notation hurts brain

MattMax

New Member
Joined
Nov 13, 2009
Messages
34
Hello...

I'm writing a macro that creates a summary worksheet that references data from other worksheets. I want the summary page to be dynamic so that if the user changes drop downs on other pages, the cells update accordingly.

For example cell G2 = "=worksheet2!A2" which equals "Tree"
User makes a change to a dropdown menu on worksheet2 and A2 now equals "Flower" The cell G2 on summary page should now = "Flower"

In RC notation it would look something like this:
Range("G2").Select
ActiveCell.FormulaR1C1 = "=worksheet2!R[-7]C"

Wondering if there were other ways to write this...
 

Some videos you may like

Excel Facts

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
76,059
Office Version
  1. 365
Platform
  1. Windows
Why are you using RC notation?

Can't you just use A1?
Code:
Range("G2").Formula = "=Worksheet2!A2"
 

Watch MrExcel Video

Forum statistics

Threads
1,118,567
Messages
5,572,958
Members
412,491
Latest member
tweetytoon
Top