Programming

Referencing Defined Name in another workbook
For a vlookup function, I need to reference a name in another workbook, If the workbook is "Source Data.xls" and the Defined name in that workbook is "lookuprange" then what will the second argument in the formula below (in another workbook) be =vlookup(b2,second argument,3,false) Thanks in Advance for the he... 5 May 2010 13:48

using VLOOKUP in a text box
Hello, I have a user form with textbox1 and textbox2. I want to enter a phone number into textbox1, and then I want textbox2 to be populated from another sheet based on the value in textbox1, just like a lookup table. So the name of the person whose phone number is in textbox1 will appear in textbox2. Does anyo... 5 May 2010 13:48

Screen repainting issue
I have a workbook that now and again after running a macro (issue occurs with many different macros) the first say five or six columns are covered in grey so one cannot read the data below the grey. If you scroll to the right then all those columns up to the end (IV) are visible as usual. If you change sheets... 6 May 2010 02:02

Copy varaible no. of rows to another woorkbook
The following should work but it only copies cell A1 from the SSh (source) to cell A1 on the DSh (destination). Sub MoveData() Dim SSh As Worksheet 'source sheet Dim DSh As Worksheet 'target sheet Dim LastRow As Long Dim CopyRange As String Set SSh = ActiveWorkbook.ActiveSheet Set DSh = Workbooks("CMS Re... 6 May 2010 06:22

vbe command for making excel in the active window on top
i need exactly that !!! the vbe command for making excel in the active window on top.. tx ! ... 5 May 2010 21:37

Locked problem when using .Clear
I am using the following to Clear a group of cells; Range("AP1:AP1500").Clear however, after using this code I notice that the cells are Locked rather than Unlocked as they were originally - this then causes problems in other code I have running as the sheet is protected when distributed. Is there something ... 5 May 2010 13:48

Why is Excel 2003 changing the names of my macros??
I have a module which contains two Subs. The code of the 2nd Sub is given below. Twice since I added the 2nd Sub, Excel has changed the names of the module's macros from the names I gave them to something like: WorkbookName!ModuleName.OldMacroName I see this changed name when looking at Excel (Not VBE) Tools/... 5 May 2010 11:33

A generic "find" function
Using XL2007. I need a reusable "generic" function that I can call and feed it three variables: 1) a string to find 2) the column to find it in 3) whether to return the cell address of the first occurrence (top) or last (bottom) Can someone please help me out with this? Thanks! ... 8 May 2010 13:25

Get Column Header Value
Hi Guys Just looking for some help. Haven't written any vba for quite some years now. I have a spreadsheet with column headers along the top and column one being a description column. What I need to do is after a description is entered in rows under column A and for each row a $ value is entered under one of t... 5 May 2010 10:26

Updating another workbook
I would like to know how to take data in cell A1 of Workbook1.Sheet1 and place it in cell A1 of Workbook2.Sheet2 via a macro from workbook1? Thanks. ... 6 May 2010 15:24