Click here to Skip to main content
15,905,325 members
Home / Discussions / Visual Basic
   

Visual Basic

 
AnswerRe: VB6 to .net upgrade issue Pin
Dave Kreskowiak11-Jun-09 9:10
mveDave Kreskowiak11-Jun-09 9:10 
GeneralRe: VB6 to .net upgrade issue Pin
No-e11-Jun-09 10:50
No-e11-Jun-09 10:50 
QuestionFiltering the results of GetDirectories? Pin
Sonhospa11-Jun-09 7:32
Sonhospa11-Jun-09 7:32 
AnswerRe: Filtering the results of GetDirectories? Pin
Luc Pattyn11-Jun-09 9:00
sitebuilderLuc Pattyn11-Jun-09 9:00 
NewsRe: Filtering the results of GetDirectories? Pin
Sonhospa11-Jun-09 10:10
Sonhospa11-Jun-09 10:10 
QuestionVBA (Bar chart error: String too long) Pin
jainga1021311-Jun-09 6:57
jainga1021311-Jun-09 6:57 
AnswerRe: VBA (Bar chart error: String too long) Pin
Luc Pattyn11-Jun-09 7:36
sitebuilderLuc Pattyn11-Jun-09 7:36 
AnswerRe: VBA (Bar chart error: String too long) Pin
Sonhospa11-Jun-09 8:17
Sonhospa11-Jun-09 8:17 
Hi GJ,

I'm not quite sure if I exactly understood what you're doing, but it seems to me as if you're doubling up unnecessarily and just make the string longer and longer. Maybe you wanna try adding your cells as single elements in a loop, like

For i = 1 to x '(= Number of Series)
ActiveChart.SeriesCollection.Add Source:=Range("DataSheet!$B$4")
ActiveChart.SeriesCollection.Add Source:=Range("DataSheet!$B$3")
....
Next

If you really add each cell manually, this is a big challenge anyway.
Hope it helps,

Mick
GeneralRe: VBA (Bar chart error: String too long) Pin
jainga1021311-Jun-09 8:28
jainga1021311-Jun-09 8:28 
AnswerRe: VBA (Bar chart error: String too long) Pin
Sonhospa11-Jun-09 9:48
Sonhospa11-Jun-09 9:48 
AnswerRe: VBA (Bar chart error: String too long) Pin
Dave Kreskowiak11-Jun-09 9:07
mveDave Kreskowiak11-Jun-09 9:07 
Questionis possible GET data from web page Pin
sal2111-Jun-09 5:08
sal2111-Jun-09 5:08 
AnswerRe: is possible GET data from web page Pin
Colin Angus Mackay11-Jun-09 5:50
Colin Angus Mackay11-Jun-09 5:50 
QuestionVB6 sendkey is not working under window vista Pin
Member 367682211-Jun-09 1:38
Member 367682211-Jun-09 1:38 
AnswerRe: VB6 sendkey is not working under window vista Pin
Henry Minute11-Jun-09 2:10
Henry Minute11-Jun-09 2:10 
AnswerRe: VB6 sendkey is not working under window vista Pin
Nagy Vilmos11-Jun-09 2:54
professionalNagy Vilmos11-Jun-09 2:54 
AnswerRe: VB6 sendkey is not working under window vista Pin
Dave Kreskowiak11-Jun-09 3:40
mveDave Kreskowiak11-Jun-09 3:40 
Questiondynamic call of a function Pin
mehrdadc4811-Jun-09 1:22
mehrdadc4811-Jun-09 1:22 
AnswerRe: dynamic call of a function Pin
Dave Kreskowiak11-Jun-09 3:33
mveDave Kreskowiak11-Jun-09 3:33 
Questionbinding navigater add new Pin
nikhil123410-Jun-09 20:37
nikhil123410-Jun-09 20:37 
AnswerRe: binding navigater add new Pin
Nagy Vilmos11-Jun-09 0:16
professionalNagy Vilmos11-Jun-09 0:16 
QuestionTab Order with UserControls Pin
Andrew Holland10-Jun-09 10:11
Andrew Holland10-Jun-09 10:11 
AnswerRe: Tab Order with UserControls Pin
Johan Hakkesteegt11-Jun-09 0:27
Johan Hakkesteegt11-Jun-09 0:27 
GeneralRe: Tab Order with UserControls Pin
Andrew Holland11-Jun-09 6:25
Andrew Holland11-Jun-09 6:25 
AnswerRe: Tab Order with UserControls Pin
Andrew Holland27-Aug-09 6:00
Andrew Holland27-Aug-09 6:00 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.