| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
.Values / .XValues modification
I am trying to modify the following code from...
' .Values = "='2.1 - Surface - Solution'!$E$5:$E$12" ' .XValues = "='2.1 - Surface - Solution'!$B$5:$B$12" To... .Values = Worksheets("2.1 - Surface - Solution").Range("E5", Range("E5").Offset(0, end_21.Value)) .XValues = Worksheets("2.1 - Surface - Solution").Range("E5", Range("E5").Offset(0, end_21.Value)) Where (these are the first things): Dim end_21 as Range Set end_21 = Worksheets("2.1 - Surface - Solution").Range("M1") .... and range M1 has a value of 8 in it It gives me a application or object-defined error. I am not sure how to modify the .Values and .XValues. Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Displaying XValues and Values for chart using VBA | Charts and Charting in Excel | |||
| .XValues syntax problem | Charts and Charting in Excel | |||
| Unable to set the XValues Property | Charts and Charting in Excel | |||
| Problem with plotting a chart when using arrays as Values and Xvalues | Charts and Charting in Excel | |||
| Forcing 'XValues' to the bottom | Charts and Charting in Excel | |||
Threaded Mode
