Worksheet function
Sub qwerty()
s = "/SCC/4"
t = Split(s, "/")
MsgBox t(1)
End Sub
--
Gary''s Student - gsnu200909
"Atif" wrote:
Hi all,
i am using following code to copy values from Source Workbook to Target
Workbook, its working fine.
vSourceWS.Range("A1").Copy Destination:=vTargetWS.Range("A1")
information at source is in following format:
/SCC/4
TargetWorkbook only requires "SCC", following funtion fulfill this requirement
MID(A1,(FIND("/",A1)+1),FIND("/",A1,2)-2)
How can i achive this goal using VBA, without entering formula in Worksheet.
Regards
Atif
|