Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Dynamically select range
Hi-
I have a block of data, say A1:D10, and I have code that dynamically selects what rows in column D I want to select. So one run may grab D1:D6, and the next may grab D1:D8 depending on the criteria....etc.... The problem I have is trying to select the entire block of data. So if D1:D6 is selected, how do I then tell it to grab A1:D6? Currently I use this code: Range(Selection, Selection.End(xlToLeft)).Select....which is ok....until I get a break in the range. So if column B is BLANK, the macro will only grab columns C and D. How do I tell the macro to grab an entire block of data, starting in column A...and ending in the last row selected in column D?? Thanks, Chris |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Dynamically select range
with sheets(Sheet1)
.range(.range("D1"), .cells(rows.count, "A").end(xlup)).select end with -- HTH... Jim Thomlinson "Fatz" wrote: Hi- I have a block of data, say A1:D10, and I have code that dynamically selects what rows in column D I want to select. So one run may grab D1:D6, and the next may grab D1:D8 depending on the criteria....etc.... The problem I have is trying to select the entire block of data. So if D1:D6 is selected, how do I then tell it to grab A1:D6? Currently I use this code: Range(Selection, Selection.End(xlToLeft)).Select....which is ok....until I get a break in the range. So if column B is BLANK, the macro will only grab columns C and D. How do I tell the macro to grab an entire block of data, starting in column A...and ending in the last row selected in column D?? Thanks, Chris |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
dynamically select sheet | Excel Programming | |||
dynamically select a range of cells for use in a formula | Excel Worksheet Functions | |||
How to dynamically select a validation list from data in a cell? | Excel Discussion (Misc queries) | |||
Dynamically select a Printer | Excel Programming | |||
how to select cells dynamically in excel macro? | Excel Programming |