vba code in excel

rajpeter · #1 09-06-2011, 05:11 AM

hi
i need your help i have in sheet column 2
like Peter, RAJ

but i am comparing with other excel sheet 1 like RAJ,PETER
i am comparing sheet 2 against sheet1. here i am showing part of the code
how do i write

Code:

If Not IsEmpty(FullName) Then
intFullNameNum = InStr(1, FullName, ",")
If intEmpNameNum >= 1 Then 'Real Person's Name strEmpLNameChrUpper = UCase(Mid(EmpFullName, 1, 1))
strEmpFNameChrUpper = UCase(Mid(EmpFullName, intEmpNameNum + 1, 1))
strEmpLName = Trim(strEmpLNameChrUpper & LCase(Mid(strEmpFullName, 2, intEmpNameNum - 2)))
strEmpFName = Trim(strEmpFNameChrUpper & LCase(Mid(strEmpFullName, intEmpNameNum + 2)))
strEmployeeBothName = strEmpLName & ", " & strEmpFName
 
 
the above code shows PETER,RAJ
BUT IN SHEET 2 shows PETER, RAJ
 
Set M = Worksheets("Sheet2").Columns(2).Find(What:=x, MatchCase:=True)

THNAKS

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
VBA Code in Project to Wake Up/Open Excel	OTPM	Excel Programming	2	05-23-2011 02:24 PM
Any tutorial same as to this excel sheet with code?	Learner7	Excel	1	05-18-2010 05:31 PM
VB Code in Excel Active worksheet	shakilhyd	Excel	2	05-17-2010 07:50 AM
Excel ->VB code for Checkbox (control toolbox)	kirkstyle	Excel	0	08-16-2006 04:17 PM
Delete excel files by code in Access	Barry Richardson	Office	0	06-13-2005 06:26 AM