Programming
in [Excel]
|
Get column of named cell I have a named cell - StaffHeader1 - I want to refernce just the Column property of this cell in another piece of vba - how do I do that ? So in my code I am going to do this; iColumn = Column(StaffHeader1) Sheet6.Cells(3, iColumn + 1).Value = iStaffName Any help appreciated Thanks ... 3 May 2010 09:50
conditionally formatted list I have a conditionally formatted list of dates in red & green fonts, is it possible to show the green font cells as a percentage of the whole list? thanks rslc ... 3 May 2010 06:35
copy range Hello everybody, I have a problem: In my Sheet1 I have column A, D, G, J, M, P, S and V with values I need to copy to Sheet2. The values are only the ones that in the second column to the right have an * (so for A - C and so on). There is a format I must follow (val=value): CellA headervalOZ/valOZ.T and so on. I.E... 3 May 2010 09:50
populating neighbouring columns based on drop-down choice I have a worksheet which contains a column listing types of issues. Another column lists examples of each of these issues. (e.g., "ALT incorrect" is the issue and "ALT missing", "ALT should be empty", and "ALT not accurate" are all examples) The other worksheets all are testing results tracking these issues by web... 3 May 2010 02:18
VBA and VB.NET give different results for same RegEx code Excel 2007 & 2003 If you are thinking "Not this group" I can understand. That said, I am not sure where else to start? Assume myCell.formula = "=2620137" also FormulaText = "=2620137" Assume a "For Each objMatch In objcolMatches" which produces an "objMatch" in VBA of 2620137 But in VB.NET, the F... 3 May 2010 07:39
move item in multiselect listbox Good evening, The code below, found in this group, works fine when the multiselect listbox has 1 column, Struggling to get it work when the listbox has 2 columns but without success. Grateful for some hints. Brgds CG Rosen ------------------------------------------------------------ Private Sub SpinButton... 2 May 2010 15:22
Get column name and data type from closed workbook Good day Group, Found the code below from this group that helps me to retrieve the Sheet names from a closed Workbook. Is it possible to get the name of the columns (fields) from a Worksheet in a closed Workbook in the same way? Is it posssible to get the format (data types) of each column? As new to this... 3 May 2010 06:35
Array Limit I think the problem is with the query or the database. Have you checked the database to see if there is any empty rows in the database? Maybe delete the 1500 entry which may be empty. Often excel will stop at an empty row. Excel will use the ID column of the database. sometimes the ID column is numerical and o... 2 May 2010 14:15
Help in VBA code All, I am new to VBA. I have an xl sheet where it has the code that calculates vacation (R&R) times for employees. The code was written by a person who left the company a long time ago. But I need to make some modifications to the code and cannot fiure out how it calculates. I was able to figure out what 'a', ... 1 May 2010 22:00
import Excel worksheet to SQL Server table I have an ADO connection to SQL Server 2005 and I use SQL Server Management Studio's import wizard to import Excel sheets to tables. This is very time consuming and I was wondering what would be the best way to import the files to SQL using VBA from Excel. I currently call various stored procedures from VBA. ... 6 May 2010 02:02 |