| Thread | Last Post | Replies |
|
| Programmatically calculating formulas for new entries | 30 May 2007 18:42 GMT | 1 |
I have a series of data that is imported into specific rows/columns. There are a number of calculated columns, that for now, i have to copy and paste down to each new row. Question: is there a way to have the calculations done with out having to
|
| copying sheets | 30 May 2007 18:37 GMT | 3 |
Can I copy Sheet1 from one workbook to Sheet1 in a new workbook? Thank you.
 Signature Kevin C. Brown Developer
|
| Count | 30 May 2007 18:05 GMT | 2 |
Hi Experts, I have a question. if column A has letters A, B, C or D multiple and column B has numbers 1, 2 or 3. Column A Column B
|
| disabel print preview | 30 May 2007 17:58 GMT | 5 |
Hi .... please help me wi this problem........ in Microsoft Office Excel 2003 i need to disabled the print botton that it appears available when is selectec to the option of print preview. I am developing shared add-in in visual studio
|
| modifying code troubles | 30 May 2007 17:58 GMT | 1 |
Hello again, I got some partial help, but I am not sure how to apply the advise. I use the following code to import the values contained in a specific file called 'Copreco Daily Reading Submission'
|
| Type mismatch when copy empty cell to Access database | 30 May 2007 17:51 GMT | 1 |
I got a code to write data from Excel to Access database, but got a "Type mismatch" when copy cell B2 to "Dispatch_date" field in database, if B2 is empty. The setting of "dispatch_date" in database requires no input. Please help.
|
| Open a menu | 30 May 2007 17:49 GMT | 2 |
I am wondering the code to open up the menu option of insert a picture from scanner or camera. Thanks Greg
|
| shared document: protection issues | 30 May 2007 17:39 GMT | 1 |
I am writing a little VBA program that should enable two users to fill in data on a shared wkb. I am a fan of shielding the actual data on the worksheet(s) from direct access by the users by an interface (userforms). Thus, the worksheets are protected, and the data are submitted ...
|
| Check for a shape - then change or delete it if it exists | 30 May 2007 17:37 GMT | 2 |
I have a spreadsheet which contains lines that have been drawn using vba. During the drawing the process they are named like this myLine.Name = "Arrow" & CStr(PasteRow). The variables "myline" (shape object) and "pasterow" (long number)have been declared and defined. When ...
|
| Buttons Embedded in a Worksheet | 30 May 2007 16:53 GMT | 3 |
OK - I know - This is probably a basic questions for you experts, but I would like to know how to add buttons to a worksheet that hide and unhide specific colums, and how these commands/buttons are created. I have inherited a workbook that someone else created, and now I need to ...
|
| Font of Check Box (from Form Toolbar) | 30 May 2007 16:20 GMT | 3 |
Am I going mad? (don't answer that) I'm trying to change the font of a check box applied to a worksheet from the Forms Toolbar. Can It be done, either with VBA or using the font menu... If so, how.
|
| Help with Find function | 30 May 2007 16:14 GMT | 3 |
I really need some help here. I am trying to find a "(" within a text string in a column, but I get a #VALUE! error when I use it. =FIND("(",A2,1) How can I find the ( if it thinks it's part of the formula boundries? Please
|
| another querytable.add question | 30 May 2007 15:17 GMT | 2 |
nobody was able to answer my last one, maybe i'll have better luck with this one: when importing data from a dbf file, how can i limit the records imported to the value in one of the fields?
|
| VBA replaces formula but adds row in multiplier | 30 May 2007 15:06 GMT | 6 |
The formula in cell V2 is: =IF(BB2="SURG",(IF(H2<13,"No Outlier",(H2-13)*5128)),"Go to Med") The VBA below, copies the formula down into other cells but it replaces the multiplier of 5128 by inserting the row number into it. For example if
|
| copy the range names while coping cells | 30 May 2007 15:00 GMT | 1 |
i need to copy an area from one workbook to another. that area in cludes cells that have range names.i need a way to copy the range names as well. not only the formating and the data. do you know how i could do that?
|