Recent content by ninja1980

All Macro settings are on low.

It is saved as a *.xlsm, I just cant work out why this is happening??

Hi all I’ve got a very interesting little problem (or not as the case may be). I’ve been developing some very simple tools for my company in the form of some standard spreadsheets. We have recently switched over from Office 2003 to 2007. Below is an extract of code from the spreadsheet...

Hi, I am trying to merge data from various worksheets (all the same format) that only feature the headers and one line of data into a much larger worksheet featuring all the data from the other smaller worksheets with just the one header - minus the all headers. I having a problem making the...

That’s for your help PHV. Sorry if some people find silly mistakes irritating......but we all have to start somewhere

The range "Type_Select" is the name I've given to the cell I wish to monitor the change in. What have I done wrong to stop this working as intended??? Thanks

Hi I’m trying to produce a spreadsheet to hide a number of different rows depending upon the value of a particular cell. I’ve tried to use worksheet related events but I just can’t get it to work. Here is the code ************************************************** Private Sub...

Thanks

Hi I’ve added to following code to a project I’m working on to allow VBA to update locked cells. **************************************** Private Sub Workbook_activate() Dim wSheet As Worksheet For Each wSheet In Worksheets wSheet.Protect UserInterFaceOnly:=True '====>Allow...

Sorry, the second equation should read a/k*(1/Ng^2 – 1) = Omega(1/Nv – 1)

Hi Another day, another problem. After all the helpful responses yesterday I thought I ask for some help on the following problem that has been bugging me for quite some time. I basically need to find the solution for the following simultaneous equations: Na = (ygo * Ng) + (1-ygo)Nv...

Thanks very much. I've come up with something similar but your coding is a bit shorter and more efficient. Thanks again

Doesn’t the solver link into Excel??? I’m trying to do this entirely in VB. I’ve written the code below. The only problem is I want the value of Nc used to calculate “Term” to use later on. In my code Nc will be altered in the final If statement. Any ideas? CODE...

Hi PHV, how do I go about using Solver.XLA???? Thanks

Also, ettienne, could you give me a starting point to translate this method into code Thanks