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

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