Programming

Insert comment into cell
Dear Expert, Have 2 columns .... Column A is name Column B is type I want the content in column B to put as comments in respective column A. For example, Name Type Elton PT Jasmine PT Tony FT, 10 Kammi PT, 12 Would like to put PT as comment in cell A2 (Elton) Would like to put PT as comment in cell A3... 23 Apr 2010 11:48

Inserting the values of a formula using vb
HI All, Do you know where the error is below Thanks for any help With Worksheets("tblFaxMailBox").Range("F2:F" & LASTROW) .Formula= "= NETWORKDAYS(RC[-2],RC[-4],Holiday!R2C[-4]:R11C[-4])" .Value = .Value End With ... 22 Apr 2010 11:23

Programmatically Adding a Worksheet_Change Event Procedure to a Pr
I am using Excel 2003 and have added a script to add a Worksheet_Change Event to an Added Worksheet. I receive the following error: Error -2147417848 (80010108): The object invoked has disconnected from its clients. I have referenced the Microsoft Visual Basic for Applications Extensibility 5.3. I under... 22 Apr 2010 14:31

Change to different active printers on different PC's
Hi, Win XP Professional SP2 Excel 2003 I've been browsing through this forum, but couldn't find any usefull info for my problem. I have (for the moment) 3 PC's where i need to print to the same multitray network printer. I've setup different printers on one PC (testing purpose) so that i can change from t... 23 Apr 2010 06:36

multiple crieria searches
I am looking to have a returned cost based on 3 criterias 1. job location (cell F1) 2. Mix type (cell F2) 3. Plant (cell F3) I have it set up in a table format.... Job Loc. Mix type Plant Cost A1 B1 C1 D1 1 L 12.5 3 ... 22 Apr 2010 10:21

Print To pdf Not Working
I also face the same problem with WORD. The solution I found is to use the FREE PDF Printer (http://www.bullzip.com) This printer allows to define the name of the PDF file you want to generate. url:http://www.ureader.com/msg/103768455.aspx ... 22 Apr 2010 10:21

Variable Range Sort
Hello I am trying to setup a macro to sort a variable range. I need to sort from A3 to L, but the L row would be variable... I know if I select A3:L3 and then do End(xlDown) that would be a start but I am not sure how exactly to work this into the sort portion..... A start is.... Range("A3:L3").Select ... 22 Apr 2010 11:23

How to change the font size of Data Validation in drop-down me
Hi Guys, I have a question on this too. I followed tha instructions in the given article, and it works as described, but I have the following problems: I have my drop-down values in cells in a separate workshhet, each range having a name. The code .ListFillRange = ws.Range(str).Address doesn't work in this case.... 22 Apr 2010 09:18

macro to apply only to even number rows and NonBlank cells
I want a macro to be useable only on even number rows, AND NonBlankcells. I need something like an If Then statement? Like If ActiveCell.Row _______ Then Exit Sub? Thank you for your help. Tonso ... 22 Apr 2010 12:26

userform problems with copy/paste and drop-downs
I created a series 19 userforms that the user will scroll through to enter data. After pilot testing the form, this comment was made: "Sometimes when we click back to the forms after reviewing and copying information, we are no longer able to paste content into cells or access pull-down menus. When this occurs,... 22 Apr 2010 09:18