| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet function
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| calling a worksheet function from another worksheet in same workbo | Excel Programming | |||
| Using dcount function within user-defined worksheet function | Excel Programming | |||
| Reference the worksheet from a multiple worksheet range function ( | Excel Worksheet Functions | |||
| Can the offset worksheet function reference another worksheet | Excel Worksheet Functions | |||
| formula/function to copy from worksheet to worksheet | Excel Programming | |||
Threaded Mode
