Hi guys...

i have two excel functions that i am trying to imitate separately using vba for a programming project.
The first question is, how can i imitate the "search" function without using instr, find or search in the program code.

The second question is, how can i imitate the "trim" function without using trim in the code as well

all code suggestions are welcome

thanks lots in advance

Hi

For Search, you can load data to an Array/DB and can query it

For Trim, you can use the combination of Left, Right and Mid functions

Cheers
Shasur

__________________
C# Code Snippets (http://www.dotnetdud.blogspot.com)

VBA Tips & Tricks (http://www.vbadud.blogspot.com)