Programming

Initialise the registry values in a array and retrive the values as required
I have some data that are calculated once in an array. Now, as the calculations are very time consuming, so i won't like to perform the calculations again. So, for the first time the workbook is opened, it should do the calculations and then proceed with other operations in the code that uses the numbers inserted ... 26 Apr 2010 00:28

Range Vlookup
Hi Every One, I hope you all are doing well, I required your help to resolve my issue in excel. On single worksheet i have two different sheet name as 1.IP Range 2. Result. Question: EG:IP Range Start IP End IP Area 192.168.1.4 195.182.254.254 AG 10.15.33.10 10.... 26 Apr 2010 08:03

moved code to new book - some doesn't work now
I recently moved all the code from one workbook to another so that it could be shared amont multiple books, by making the following change in the worksheet_activate sub in Sheet1: from Call Macro1 to Application.Run "'Book2'!Macro1" Now, some of the code works, and some doesn't. For example: With Work... 27 Apr 2010 22:27

Adding to the cell value with a macro
I would like to select a cell with a product code (let's say cell B6 contains Part #ABC). I would like to activate that cell, click on a button to run a macro to change the quantity (lets say quantitiy is in cell A6.) If A6 is currently 0, a click would change it to 1. if it is 2, a click would change it to 3.... 25 Apr 2010 16:44

Excel and Windows Live Mail
Hi all I update my Mail add-in and VBA code examples to avoid the error if you use Windows Live Mail as your default mail program. More information in the blog post : http://www.dailydoseofexcel.com/archives/2010/04/25/windows-live-mail-wlm-and-excel-problem-part-two/ If you have problems let me know so I can... 25 Apr 2010 13:17

VBA Digital Signature not working
Have you found a solution to this yet? I have the same exact problem except I did not upgrade. I purchased a new computer in March with OS of Windows 7 Home Premium (x64) and didgital signatures do not work as you indicate in your problem description. On my old computer was running Vista I did not have a problem. On t... 25 Apr 2010 12:10

C application connected to Excel
Can anyone give me a clue what shall I ask my company programmer in order to have his C developed software conected with Excel (VBA)? I m dreaming of not being necesary to ask him to do anything to connect his application with Excel beside SendKeys ...Any suggestion will be appreciated! Thanks!!! -----------... 26 Apr 2010 03:42

Delete contents of cells in a range based on value of a cell
I want to be able to delete the contents of a range of cells (A100:K200) based on the values I manually enter into cells A1 and B1, everything to run in Sheet1. A1's entry is the first row of the range to delete (A100:K100) and B1's entry is the last row of the range (A200:K200). Can someone provide a fairly simp... 25 Apr 2010 14:25

Tagging formatting (cells with mixed formatting)
I need to tag all formatting (bold, itlaic, bold italic, superscript, underline, etc) in all the cells throughout a worksheet. The way I am doing it is looping through each cell of the UsedRange and then through each character of each cell. I am wondering if there is a better/faster way to do this. Any help wou... 25 Apr 2010 11:02

Formula ?
I got 3 columns in excel. First two is ID & Name, third column is a subset of the 2nd Column. Now, I want the corresponding ID's for my 3rd column (which should be looked up in first 2 columns) in my 4th column. ID,Name,Subset-name,Subset-ID? -- Failing to plan is planning to fail ... 26 Apr 2010 11:24