between commas
Use the SPLIT() function
strData = "10K,0,45" varData = Split(strData, ",") For intTEmp = 0 To UBound(varData) MsgBox varData(intTEmp) Next OR strData = "10K,0,45" Msgbox SPLIT(strData,",")(0) Msgbox SPLIT(strData,",")(1) Msgbox SPLIT(strData,",")(2) If this post helps click Yes --------------- Jacob Skaria " wrote: my values are like 10k,0,45 0,01,h7 14,0,0 How can i get these 3 values separeted by 2 commas via vba ? Thank you very much in advance. |
between commas
If this post helps click Yes
Yes,Yes,Yes,Yes,Yes,Yes,Yes,Yes. Thank you very much. |
All times are GMT +1. The time now is 09:55 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com