| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select a range in a column in currentregion
What is the best way to go about dynamically selecting a range in a
column? I've been trying to do it in one line like CurrentRegion.Offset(1,brainfart).FormulaR1C1 = "=RIGHT(RC[2],3)&RC[3]" The number of record varies greatly in my project and I'm trying to keep the amount of time it takes to run to a minimum. Thanks to anyone that can help with this. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| select a range in a column | Excel Discussion (Misc queries) | |||
| Select range using row and column number addresses | Excel Discussion (Misc queries) | |||
| select date range in column | Excel Worksheet Functions | |||
| select a range base on Column A | Excel Programming | |||
Threaded Mode
