Posted to microsoft.public.excel.programming

external usenet poster

Posts: 972

Referencing 2 cells in a macro

I've got the following code which I am trying to add the following 2 columns
thru cell refences and am getting a compile error. I am not sure what I am
doing wrong since it works when I only reference 1 column.

Worksheets(Sh).Range("W" & X).FormulaR1C1 = "=((RC[" &
Sheet(1).Range("D32")+ RC[" & Sheet(1).Range("E32")& "]/Sheet1!R21C4*52)"

--
Thanks.

Bob

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
referencing cells based on conditions in other cells	mirskman	Excel Discussion (Misc queries)	1	January 29th 09 09:57 PM
Referencing the same cells	Kenton	Excel Discussion (Misc queries)	6	November 25th 08 09:57 PM
Referencing cells	cate	New Users to Excel	3	April 26th 06 08:34 PM
referencing previously selected cells after macro execution begins	Glenn	Excel Programming	5	October 15th 04 12:52 AM
Referencing Cells	Sok Hong	Excel Programming	1	August 5th 03 02:28 PM

All times are GMT +1. The time now is 07:31 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us