Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find/Copy Variable length range
I'm trying to make a macro to search a column for when values are
greater than zero (it will be a variable length range). Usually, this column being searched is column T in the worksheet. Once that range is found, it will need to select the five cells above the range (where values are zero), and the five cells below the range (where values are also zero). These three smaller ranges are added together to make a single range. In the six adjacent columns before the one searched, there is data that needs to be graphed corresponding to the searched range. I'd like it to make a new worksheet for each of the six data, copy the data from the main sheet into the individual pages, and then graph the data. Any help is appreciated! Thank you. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Variable series length/range | Charts and Charting in Excel | |||
Copying RANGE of variable length | Excel Programming | |||
copy variable length cells to a new sheets | Excel Programming | |||
Using a Macro to Sum a Variable-Length Range (a Column) | Excel Programming | |||
Using a Macro to Sum a Variable-Length Range (a Column) | Excel Programming |