Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-06-2011, 09:20 AM
Catalin.B Catalin.B is offline vba code in excel Windows Vista vba code in excel Office 2007
Expert
 
Join Date: May 2011
Location: Iaşi, Romānia
Posts: 386
Catalin.B is on a distinguished road
Default

Quote:
the above code shows PETER,RAJ
BUT IN SHEET 2 shows PETER, RAJ
Code:
strEmployeeBothName = strEmpLName & ", "& strEmpFName
sorry, but the above code shows PETER, RAJ not PETER,RAJ as you say (look at the line 7 in your posted code)
at this row in your code, it says : put between the last name and first name a comma and a space... if you don't want a space between names, just delete the space after the comma...


and you can change in your code the lower case to upper case to match the format in the other sheet...
How do you want to use the results of this comparison?
(maybe if you upload a sample with data and desired results, will ease communication...)
Reply With Quote
Reply



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
vba code in excel Any tutorial same as to this excel sheet with code? Learner7 Excel 1 05-18-2010 05:31 PM
vba code in excel 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

Other Forums: Access Forums

All times are GMT -7. The time now is 03:07 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft