Search results for query: *

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

Thanks everyone, especially ettienne Also, Andrzejek, what is the benefit of declaring the variables inside the function? Its just I’ve never even thought of doing it before now Thanks

Hi all I’m trying to solve an equation via an iterative method. The VB code below shows a simple loop I’ve created to solve for Nc. Stricly speaking, Nc is found when when “Term” is equal to 0. I’m fairly new to VBA and would really like a few pointer on how to make this sort of routine more...

Hi I regularly use the Excel Functions INDEX() and MATCH() to return values in look up tables from input data. For example: =INDEX(Array,MATCH(43,Array2,2)+1,2) I really want to be able to perform this function in VBA in the most efficient way possible. Can anyone give me any tips? Thanks

Thanks, that worked perfectly. I can see the problem now On a slightly unrelated matter. When operating a macro, is there any way to stop it stealing the focus of the screen i.e. say the macro was formatting data on several sheets. I would prefer if I could make the screen stay on the...

I’m basically trying to create a spreadsheet to model the temperature of pipe work as low temperature gas travels down it (during blowdown). I’ve set up an Input worksheet which end users will input their specific data and then a graph is drawn below summarising the results. The input data is...