| Thread | Last Post | Replies |
|
| Setting Variables | 24 Apr 2007 15:19 GMT | 5 |
I've compiled the following code to open a file (determined by value in range D10), identify range of cells to be copied, then copy them into the next available row in another spreadsheet. Sub Import()
|
| Digital certificate in outlook | 24 Apr 2007 15:10 GMT | 1 |
In outlook when I click on Tools Options Security and select my own certificate there is a reigstry entry in the registry at the following path HKEY_CURRENT_USER\Software\Microsoft\Windows NT\CurrentVersion\Windows Messaging ...
|
| Moving a worksheet to a new workbook when you do not know the name of worksheet | 24 Apr 2007 14:36 GMT | 2 |
I am trying to move 2 worksheets from 1 workbook to another where I know the name of 1 worksheet but only have a variable with the name of the 2nd worksheet. When I try the following..... Sheets(Array(ThisSheetName, "Attribute Definitons")).Move
|
| how to autofill a consecutive cells in a column? | 24 Apr 2007 14:21 GMT | 1 |
This problem has bugged me for a long time. Please help! I have column A with 2, 4, 6, 8, ....100, which represents the time line in days. Column B with 0, 0, 1, 0, 3, 2, ...5, 3... which represents a certain event that happend in that day. Let's say totally the event happened ...
|
| E - Mail when sheet updates - hyperlinking ! | 24 Apr 2007 14:12 GMT | 2 |
I've checked out Ron DeBruin's great site on e - mailing from excel, but need some assistance on the following. My scenario: when an engineer updates his project log, I would like him to be able to press a button and send an alert to the review group advising them of the update.
|
| Using OE to post and read newsgroups | 24 Apr 2007 13:59 GMT | 2 |
This may not be the best forum for these questions, but I know I always get timely and reliable replies here; I just discovered that you can read and post to the news groups using Outlook Express; I like this functionality; however, I can't find a way to
|
| Real-time character counter | 24 Apr 2007 13:38 GMT | 14 |
Excel 2003 I am trying to display a character counter in real time. Scenario: An Excel form has a comment cell where the user types a comment. (We all know that Excel can display 1024 characters in a cell and 32,767 in
|
| Select Range Name Q | 24 Apr 2007 13:28 GMT | 7 |
Beginners Q The code below I am using to try and clear the contents of 12 range names, but it doesn't clear any info, the range names are correct, not sure what is wrong
|
| script to send data from worksheet to multiple workbooks | 24 Apr 2007 13:06 GMT | 6 |
Hi. Can anybody offer me some words of wisdom on how to approach the following... I want to create a data entry worksheet that links to multiple workbooks. To be more specific, the data entry worksheet is a school
|
| Copy values (loop) from TXT file to excel | 24 Apr 2007 12:25 GMT | 9 |
I have a problem wich i cant seem to resolve. Posted it before, but this is hopefully a better explanation; Have a txt file with alot of data placed in one row (50.000 rows). Across this row of data there is a constant value coming back called
|
| Using COUNTIF with an AND? Or is it something different? | 24 Apr 2007 12:05 GMT | 1 |
I hope that someone would be able to point me in the right direction as I seem to have been working on my problem for some time without success. Here is the situation: I have two columns that I want to use. Column V will have numbers
|
| create chart in worksheet but hide the data from user | 24 Apr 2007 11:57 GMT | 1 |
Is there any way to hide the data from user & just create & show the chart? I have the data on sheet 1 & i created the chart to be shown on sheet 1.
|
| Setting RGB colors for a set of cells. | 24 Apr 2007 11:48 GMT | 5 |
Iv got a huge problem with setting RGB colors in excel for difrent cells take a look on my script: Sub ColorCellBasedOnCellValue()
|
| command which returns the position of cell | 24 Apr 2007 10:24 GMT | 2 |
I have a macro that searches a string in another sheet. when it finds I have to proceed a series of calculus dependending on its position. Does anybody know a command which returns the position of the cell
|
| Excel DAta Import | 24 Apr 2007 09:56 GMT | 2 |
Our company uses Pegasus Opera a Visual Foxpro Accounting package. We have numerous pivot tables linked into tables from the accounting package. In the last few days the accounting software has been upgraded and this time has installed the software into a new folder on the ...
|