LG915
03-02-2013, 03:40 PM
can you please tell me why I get the error: http://www.mediafire.com/view/?myfiles#5si0tk286m118sa
Compile error: Expected line number or label or statement or end of statement? do I need to add semi columns in my raw .csv? or commas?
when using:
Sub ReplaceText()
Dim c As Range
For Each c In Module1.UsedRange
c = Replace(c, ".", ",")
Next
End Sub
and module1 is an imported raw csv which contains:
0.989492209703375
0.184145098978442
0.365063754808973
0.253380136210709
0.512303430515757
0.279467114522703
0.558206434256604
0.302325086649532
0.292949402615390
0.110894333578039
0.771168133470690
0.703253925307222
0.421389240839892
0.472149722783674
0.176969965078023
0.706427742557473
Compile error: Expected line number or label or statement or end of statement? do I need to add semi columns in my raw .csv? or commas?
when using:
Sub ReplaceText()
Dim c As Range
For Each c In Module1.UsedRange
c = Replace(c, ".", ",")
Next
End Sub
and module1 is an imported raw csv which contains:
0.989492209703375
0.184145098978442
0.365063754808973
0.253380136210709
0.512303430515757
0.279467114522703
0.558206434256604
0.302325086649532
0.292949402615390
0.110894333578039
0.771168133470690
0.703253925307222
0.421389240839892
0.472149722783674
0.176969965078023
0.706427742557473