| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Setting a range that varies
I am trying to create a chart from a range that has dates in Column a
(starting at Row 5) and share value in Column B THis works Range("A5:B7").Select but what I can't find how to do is how to set it from A5 to the last cell with data in column B rather than B7 because as I add data I want the chart to update. I am sure it is very simple. Any clues please Stephen |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can a range be copied if it varies in size? | Excel Discussion (Misc queries) | |||
| % allocated over time varies | Excel Worksheet Functions | |||
| Sum of a range that varies | Excel Discussion (Misc queries) | |||
| Excel Addin:Setting the range to the Excel.Range object range prop | Excel Worksheet Functions | |||
| VBA setting Range | Excel Discussion (Misc queries) | |||
Threaded Mode
