Search results for query: *

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...

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...

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...

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...

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

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...