Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Replace/substitute
I want to change the series of existing charts. As I do it now (and it works
but with some problems) I just assign new values. Perhaps it is better to use Replace/substitute? I have never used them and the help function in vba is in some foregin language. Please if you know how to use them help me out? Me code the charts series replacement is: Do While k < (UBound(rng)) If Not IsEmpty(rng(k)) Then ActiveChart.SeriesCollection(varWorksheetInfoArray (k)).Values = Sheets(varWorksheetInfoArray(0)).Range(rng(k).Offs et(i, 0).Address & ":" & rng(k).Offset(j, 0).Address) Else: End If k = k + 1 Loop |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find and Replace/Substitute Formulas | Excel Worksheet Functions | |||
Substitute/Replace | Charts and Charting in Excel | |||
Replace or Substitute for COMBIN function | Excel Discussion (Misc queries) | |||
Substitute ,replace and delete in a cell. | Excel Worksheet Functions | |||
Using substitute to replace text that varies | Excel Programming |