| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Dynamic range w/in formula in macro
Hello, I have been trying to figure out if there is a way to allow a dynamic range within a formula in VBA. I have this static range, but the end row could change as data is added/deleted: Range("K11").Select ActiveCell.FormulaR1C1 = "=COUNTIF(R[-9]C[-6]:R[18]C[-6],"""")" I'd like to be able to change the R[18] to whichever row the user would put into an input box at the beginning of the macro. Thanks! -- Trixie ~TRIXIE ------------------------------------------------------------------------ Trixie's Profile: 438 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=175466 Microsoft Office Help |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dynamic Range Name Macro | Excel Discussion (Misc queries) | |||
| dynamic range in a macro | Excel Programming | |||
| dynamic range based on criteria, within a dynamic range, passed to a function | Excel Programming | |||
| creating a dynamic range based on criteria, within a dynamic range, and passing it to a function | Excel Programming | |||
| Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
Threaded Mode
