Programming

Select the UNIQUE vendors name
Dear All, Please help how to replace the below function with the VBA solution: =OFFSET($G$1,MATCH(0,MMULT(--TRANSPOSE(TRANSPOSE($G$1:$G$14)=I$1:I1),ROW(INDIRECT("1:"&ROW()-1))/ROW(INDIRECT("1:"&ROW()-1))),0)-1,0,1,1) the above formula work fast, when then data is not many. But when we would like to SHORTLISTED... 24 Apr 2010 10:33

Extracting First Name from cell with first name and last name
I have searched several posts and am still stumped. I have a first name and last name in Cell B10 on Sheet1. I want to extract the first name with no spaces. It is part of a bigger code where I am opening outlook and making an email. The end result is to use the person's first name in the saluation. I have all... 23 Apr 2010 21:42

Open VBA Editor?
Hi, Is there a way I can open the vba editor from a command button? ... 25 Apr 2010 11:02

2007 Sharepoint XMLMap
In excel 2003 I was successful in linking and XML map to a sharepoint list. The following code was usedto refresh the list within my excel from sharepoint. Sub UpdateList() ActiveWorkbook.XmlMaps("MyList_Map").DataBinding.Refresh End Sub Still works great in 2003, fails in 2007. Any suggestions? Tha... 23 Apr 2010 15:00

Need a code
I need a code that does the following: If C3>D3, B3 value will start blink and if C3<D3, E3 value will start blink. Any help please. Thanks in advance. ... 23 Apr 2010 13:55

If cell contatin string like .... copy in Offset mode
Hi , and a good day everybody Please to help me with this problem : I have in a range (f or example : A1:E100 ), in different cells , numbers like in the follow format /(string) like : 12-16-18-25-33-43 ; The other cell contain another values , like : 3 , - , etc . I need a code to loop through my rang... 23 Apr 2010 21:42

RowSource
I have a named range, "CashierList" that I would like to populate a listbox/combo box when the userform is initialized. When I attempt this the code crashes with error 380 (Could not set the RowSource property. Invalid property value). If I insert the code, "Me.listbox1.RowSource = Range("CashierList")". If I h... 23 Apr 2010 13:55

Remove unnecessary rows
Dear expert, Every day, will get a system generated file. Have a list of names, duties, work ..... Sheet name is called Summary. I have a sheet name called Work. Is it possible if the names shown up in sheet "Work" will be retained, the rest will be removed in sheet "Summary". Name Type Time Shift Work 112... 24 Apr 2010 02:48

Auto Fill
I am creating an inpatient log and need the Name and Address fields to automatically pull in when the ID # is entered. ... 23 Apr 2010 13:55

Excel Macro Problem
Basically I've tried to create a macro that opens up all the files in one of my folders and refreshes the querys in them which bring though new data from Access. But Excel is determined to try rushing through the steps and save/close the files before the refresh/calc has finished! Is there a way around this. ... 23 Apr 2010 13:55