Programming

Generate random numbers - Using initial seed
Im looking for an addin og a tool in Excel to generate numbers using initial seed. Are there any tool available? Helge ... 13 Apr 2010 02:57

lookup help
Hi, Is there any way of simplifying this formula, mainly the lookup part. =IF(COUNTIFS('EOT Register'!$D$2:$D$92,Program!C16,'EOT Register'!$O$2:$O$92,0)=0," ","EOT under review - "&LOOKUP(C17,'EOT Register'!$D$2:$D$92,'EOT Register'!$B$2:$B$92)& " " &LOOKUP(C17,'EOT Register'!$D$2:$D$92,'EOT Register'!$F$2... 13 Apr 2010 01:52

Toggling xlVeryHidden
I am trying to write a macro for use in Excel 2003 & 2007 that will toggle between hiding (using xlVeryHidden) and unhiding a specific worksheet (Sheet2). I know how to perform a "normal" hide/unhide using the following code: Sub HideUnhide() Sheets("Sheet2").Visible = Not _ Sheets("Sheet2").Visible End Su... 13 Apr 2010 11:43

Copy Cell from one sheet to specific Col value
Hello, Need help in a VBA format. Sheet2 has a column of 15 rows, random numbers. i.e.H2 to H16 I need to sort these cells on Sheet1 with column headings 1 to 49 starting at row A25 going down again 15 rows A39 Therefore,that I may visually see a pattern of these 15 numbers. With Thanks ... 13 Apr 2010 17:22

Search and filter mutiple vaules
Hello I've got a spreadsheet that I need to search on a part number and get it's price, however there may be multiple part numbers, and the determining factor would be the revision of that part. such as ... Part number Rev Price 1234 A 13.00 1787 G 16.5... 13 Apr 2010 09:29

button on macro recorder doesn't toggle
There is a toggle button on the button bar next to the Stop Recording button. In my case it is locked on Relative recording. Any suggestions? ... 12 Apr 2010 22:34

Insert Image with name and filepath
I have three columns formatted as below. I want to read the value in column B and insert the image in column C. All images are located in a specific folder and I need all the images to be inserted into a standard cell size. Is there a way to cascade down thru the list and insert them programatically? OR ... 12 Apr 2010 18:09

Formula to copy cell in Excel from on file to another
Hi, I have 19 excel files in a folder and I have created another excel file (B) in which I am trying to set a formula that can look in Cell "A6" which has the path with the file name of the first file (1) then copy From the first File (1) cell "L25" an place it in Cell "Y6" of File (B). I want the file names or... 12 Apr 2010 21:28

Is it possible to assign fonts using formular?
Can I code a script that will, based on a selected value, format a cell, and then fill it with a result of another cell's lookup value, carrying the font that the code assigned based on the selected "font choice"? Then, my next selection would run the code again, so the code would have to have several format... 12 Apr 2010 17:03

class modules versus modules
All, Just a basic question... when I write my macros I'm using just modules. I've never used a 'class module'. Can someone fill me in when I should be using the classy one? Thanks, Matt ... 12 Apr 2010 17:03