| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
OFFSET Syntax
I recorded a simple macro that places the subtotal formula in a selecte
cell. Is there a way to use OFFSET to force the formula to star reading 2 lines below the selected cell and to the end of the colum data? Here is what I am currently using but it doesn't work correctly if th selected cell is below the 2nd row. Selection.FormulaR1C1 = "=SUBTOTAL(9,R[2]C:R[65535]C)" Any help would be greatly appreciated. thanks, Scot -- Message posted from http://www.ExcelForum.com |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IF, THEN SYNTAX | Excel Worksheet Functions | |||
| vba syntax | Excel Discussion (Misc queries) | |||
| Compare Cell Values, Offset(-1,0), Offset(-1,-1), and xlFillDefaul | Excel Worksheet Functions | |||
| Need some syntax help, please | Excel Programming | |||
| Syntax | Excel Programming | |||
![Scott1523[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
