Programming

Lookup Table
i am trying to write a formula so that i can do the following from the table WORKING PRESSURE BY ANSI CLASS (psig) Temp (°F) 150 300 600 900 1500 2500 -20 285 740 1480 2220 3705 6170 100 285 740 1480 2220 3705 6170 200 260 680 1360 2035 3395 5655 300 230 655 1310 1965 3270 5450 400 200 ... 5 May 2010 14:55

insert a dash
I have a column of numbers, 5 digit up to 9 digit. I need to insert a dash after the first number of any 5 digit number, and a dash after the second digit if the number is longer than 5 digits. so 12345 would need to become 1-2345 and 1234567 would need to become 12-34567 If my original numbers are in colum... 5 May 2010 16:03

ScreenUpdating
Hi all !! when I use Application.ScreenUpdating = False at the beginning of a Sub, will it propagate to other subs thet are called by this first one, even if they are in other workbooks , or i have to write it also in the called subs ?? Does it makes any difference if I dont' write Application.Scre... 5 May 2010 18:17

Problems executing commands on one file from another
I am executing a macro from one worksheet and wish to perform actions on another. With the commands below, I am able to open the existing file called "destinationfile" which contains a number of worksheets. It's with the 2nd command line below where I get an error message; for some reason, I am unable to... 7 May 2010 18:58

MACRO BASED ON A NUMBER OF CHARACTERS
I have the following code in a macro and it works fine. The format of my original report changed, so i need the macro to do pick up data where certain criteria are met. If Range("Salesp") <> "" Then Call XXXXXX I want this line to keep looping if the amount of characters is above a certain number. in ot... 6 May 2010 02:02

Last Column With Data
How do I check a certain row to find out the last column in the row that has data? ... 5 May 2010 21:37

With Sheets("wildcard")
How can I use a wildcard in a With Sheets statement? I have written a macro that works on sheet ScoreCard. However, during the export process if the end user saves the workbook rather than open it ScoreCard is changed to ScoreCard.Bob or ScoreCard.Alice. I need to do something like this to make the macro wor... 5 May 2010 13:48

transfer data range from criteria in 2 combo boxes
i have 2 combo boxes "com1" and "com2" i want the value in "com1" to help me decide which columns to target and i would like "com2" to decide which rows to target from another worksheet "sheet2" example: if the value of "com1" was "red" and the value of "com2" was "5/1/10" then i can return C5-C35 from "shee... 5 May 2010 12:40

I want to format lines in my footers
Hello, I need to have 3 lines in my footer, with different font formats on each line so the top line is built from a string, and is Arial 12 Pt Bold The next line is a different string and should be 22pt Calibli And finally the last line is a third string and Times New Roman 8pt The strings will be different le... 6 May 2010 03:07

Parsing thru columns to find the last number
I have six columns of data and am unsure how to get to the final replacement of an item. See, col A is the itemcode, then b,c,d,e,f contain item codes that have replaced the col a item. Not all items have been replaced five times, some none, some only two, in this case col b would be blank and or col C would... 5 May 2010 19:25