Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am trying to use vba code to enter a formula similar to the one below.
ActiveCell.FormulaR1C1 = "=R[-31]C-R[-32]C" The differences are that the [-31] and [-32] are dependent upon the number of rows in a section of the spreadsheet. They can be calculated by the following: Num1 = Range("Top_adj:Bottom_adj").Rows.Count + 3 and Num 2= Range("Top_adj:Bottom_adj").Rows.Count + 2 What is the code? Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Color Coding cell based on date (over a large range) | New Users to Excel | |||
converting question; function, formula, or coding? | Excel Worksheet Functions | |||
hard coding a cell | Excel Discussion (Misc queries) | |||
Formula Color Coding | Excel Discussion (Misc queries) | |||
VB coding to go to last cell at end of any given row? | Excel Programming |