| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
R1C1 Property in VBA module
Hi all,
I am in my spreadsheet and attempting to automate it. I want to plac a formula in (for example) cell D3 which says =C3*B3. I have the following line of code where D3 is the Active Cell: ActiveCell.Formula = "=RC[-1]*RC[-2] and it works However I then want a formula in E3 to say C3-C2. My question is how to reference cell C2 if RC[-2] refers to C3 an RC[-3] refers to B3. Hope I've made myself clear Many thanks Seamu -- Message posted from http://www.ExcelForum.com |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| help on Converting R1C1 to A1 and A1 to R1C1..tia sa2 | Excel Discussion (Misc queries) | |||
| help on Converting R1C1 to A1 and A1 to R1C1..tia sa2 | Excel Worksheet Functions | |||
| CLASS MODULE & SIMPLE MODULE | Excel Discussion (Misc queries) | |||
| code in module A to not execute a Worksheet_SelectionChange sub of another module | Excel Discussion (Misc queries) | |||
| Variable from a sheet module in a class module in XL XP | Excel Programming | |||
![SOS[_28_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
