Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
My question is about how to determine a cell location, I mean, if I use:
ActiveSheet.Shapes.AddLine(2, 2, 10, 10) Then the location starts at 2,2 and ends at 10,10, but if I want that the line starts at the center of cell A5 and ends at the center of C10 ¿How to accomplish it??? I need the preceding because I have a sheet with numbers: A B C D 1 1 2 2 0 1 3 3 1 2 4 4 2 3 5 5 3 0 4 6 6 4 1 5 7 7 5 2 6 And this numbers represent grades of an especial test, each test (columns) has its own numeric scale (rows) but a graphic should be made to present the results of the test. The user grades could be 1,4,1,4 then lines must be drown from 1 to 4 then from 4 to 1 then from 1 to 4 Hope this have sense Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
CELL LOCATION | Excel Worksheet Functions | |||
Macro - save to current location vs excel default location | Excel Discussion (Misc queries) | |||
automatic offset cell location when there is a value in a selected cell. | Excel Worksheet Functions | |||
Mouse Location, Movement and Spreadsheet Location | Excel Programming | |||
Populating one cell with the physcial location of a different cell | Excel Programming |