Programming
in [Excel]
|
Using Select Case on Single column only I'm writing code to standardize a report I get from someone. 1. I need to change the single character value in each cell to the actual name using Select Case Example if cell value = B then "Bacon" else if value = C then "Cheese" else if value = E then "Eggs" etc I've gotten the following code using example f... 21 May 2010 15:03
I need VBA Help for Excel spreadsheet -- Please! I have an Excel spreadsheet with three columns: ColA has a student number, ColB has a comment, and ColC has an amount. I have many rows of different comments and amounts for the same student number followed by rows with new student numbers and so on. I need to move all of columns B and columns C to the same r... 21 May 2010 23:49
General Question on one line of code - parentheses and quotation marks I don't understand the following line of code. "=MID(R[0]C[-2],INDEX(FIND({""(403"",""(587""},R[0]C[-2]),MATCH(TRUE,ISNUMBER(FIND({""(403"",""(587""},R[0]C[-2])),0)),14)" 1. Why and when should square brackets be used? 2. Why & where should curved brackets be used? 3. Why are there double sets of quotation mar... 21 May 2010 15:03
RowSource property in cbox I have a horizontal range named "TranList" that I want to use as the RowSource of a UserForm combo box. I tried entering the range name into the RowSource property and using the Transpose function for the range in UserForm_Initialize but can't seem to get it to work. Any help would be appreciated. Thanks, ... 21 May 2010 15:03
Change Gradient Fill Colors of Bar Chart data points I'm trying to modify the gradient fill colors of single data points on a bar charts (in Excel 2007). The bar chart already has gradient fills defined manually. I think I need to alter different child properties of .Interior, not the ..ColorIndex property that would apply to non-gradient fills. I've waded thro... 21 May 2010 21:39
delete single occurances in a string i have headers in a5:g5 I have data in columns A6:G5000. based on the series of numbers in column b, i want to delete all single occurances of the number found. In other words, if it is not listed/found in column B at least twice, delete the entire row. ... 21 May 2010 13:56
Converting a number (17 characters) to text (Scientific Notati Dave, Can't thank you enough for the reminder aoubt the 17 didget truncation... (Saved alot of rework here...) I could not figure out a way to import as text... (no filed definitions like open workbook...) But, when I tried importing the XML in access, it recognized it as text, and the import worked flawle... 21 May 2010 11:43
xlPasteValues is also pasting Formats This line in a peice of code I've inherited, is pasting formats as well as values... Selection.PasteSpecial Paste:=xlPasteValues, _ Operation:=xlNone, _ SkipBlanks:=False ....can anyone suggest why or how I get it to only paste values? In case its relevant, I've... 21 May 2010 12:49
get Control of a Butoon placed in the Sheet I have button placed on a sheet from "control toolbox" I need to change the caption of the button thru code. I found the following link at ozgrid . com http://www.ozgrid.com/forum/showthread.php?t=74185 There I saw two approches, but both are failing for me. I tried to test with following codes. These cod... 21 May 2010 09:31
Redefining a table range with a macro Hello, I need help creating code to redefine a table within a macro. I used the macro recorder to creata a table with the same name but to point to another locations. ActiveWorkbook.Names("Table1").Delete ActiveWorkbook.Names.Add Name:="Table1", RefersToR1C1:= _ "='Sheet1'!R3C28:R12C37" Ho... 23 May 2010 10:18 |