Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Range question in VB
I have a spreadsheet with data in column A starting from A5 ... list o
my pH reading for my aquarium. I also have a chart graphing this data Right now my data start at A5 and end at A11. Right now I have created a macro in VB that allow me input the las cell of my data (example A12, A15), and then used that range (e.g A5:A15, if I entered A15) to update my graph. I was wondering if anyone knew how to retrieve the range using VB o the selected cells. Another word, I want VB to return startig range A and ending range A15 if I selected A5:A15. I can then use that info t update my chart thus giving me more flexibility. Any help would be appreciated -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Range question in VB
To return the first cell in a selection:
dim firstCell as range set firstCell = selection.cells(1) msgbox firstCell.address for the last cell: dim lastCell as range with selection set lastcell = .cells(.cells.count) 'note the period in front of cells end with msgbox lastcell.address Bob Flanagan Macro Systems Delaware, U.S. 302-234-9857 http://www.add-ins.com Productivity add-ins and downloadable books on VB macros for Excel "rohnds " wrote in message ... I have a spreadsheet with data in column A starting from A5 ... list of my pH reading for my aquarium. I also have a chart graphing this data. Right now my data start at A5 and end at A11. Right now I have created a macro in VB that allow me input the last cell of my data (example A12, A15), and then used that range (e.g. A5:A15, if I entered A15) to update my graph. I was wondering if anyone knew how to retrieve the range using VB of the selected cells. Another word, I want VB to return startig range A5 and ending range A15 if I selected A5:A15. I can then use that info to update my chart thus giving me more flexibility. Any help would be appreciated. --- Message posted from http://www.ExcelForum.com/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Range question in VB
Another handy tool that might be of use. Assuming the range
starts at A5 and there are at least 2 data points. The end of the range can be found by: "A" & Range("A5").End(xlDown).Row "Bob Flanagan" wrote in message ... To return the first cell in a selection: dim firstCell as range set firstCell = selection.cells(1) msgbox firstCell.address for the last cell: dim lastCell as range with selection set lastcell = .cells(.cells.count) 'note the period in front of cells end with msgbox lastcell.address Bob Flanagan Macro Systems Delaware, U.S. 302-234-9857 http://www.add-ins.com Productivity add-ins and downloadable books on VB macros for Excel "rohnds " wrote in message ... I have a spreadsheet with data in column A starting from A5 ... list of my pH reading for my aquarium. I also have a chart graphing this data. Right now my data start at A5 and end at A11. Right now I have created a macro in VB that allow me input the last cell of my data (example A12, A15), and then used that range (e.g. A5:A15, if I entered A15) to update my graph. I was wondering if anyone knew how to retrieve the range using VB of the selected cells. Another word, I want VB to return startig range A5 and ending range A15 if I selected A5:A15. I can then use that info to update my chart thus giving me more flexibility. Any help would be appreciated. --- Message posted from http://www.ExcelForum.com/ |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Range question in VB
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Range question in '97 | Excel Discussion (Misc queries) | |||
Used Range Question | Excel Programming | |||
Range question | Excel Programming | |||
If Range.Name question | Excel Programming | |||
Range.Formula and Range question using Excel Automation | Excel Programming |