Recent content by BFG2

Was hoping someone could help. Have been using Excel vba which is linked to Fortran functions within a dll for some time now. However, I can't get it to work with subroutines which have more than 2 variables that are to be passed back. Any suggestions? A simple example would be much...

Don't worry - have sorted it. For some reason excel is happy when it's one dynamically ranged column, rather than a set of ranged cells. Bizarre.

Hi, Was wondering if anyone has any ideas. I've set up a spreadsheet with a load of monthly data, with the plan being that say, for example, in the month of January, a pie chart will show the breakdown of data for, you've guessed it - January. The ranging works fine, and I keep trying to set...

Geoff, have a small shiny thing for your first post, but Glenn, thanks to you as well for your speedy post. Have a shiny thing as well! Cheers, BFG

if possible, I really would appreciate some help with the following: I've got a shared computer (Win XP) that is connected to B/band, all on one login. When IE loads, it has started linking to a file called 'secure.html' in the windows directory. Have tried resetting the homepage (it gets set...

OK, one final question, Using that result e.g. H5, how could you then use that to form an array of the form B5:H5? I.e. use the result as part of the array reference? Cheers for this.

xlbo, Genius!! Thanks.

Oh, and I should have said..... no VBA!! ;-)

Here's a challenge (or maybe not) for you LOOKUP experts out there..... Say you've got a table of data of the form: Item 1 2 3 4 5 6 7 8 Data 1 2 12 7 6 3 4 9 4 Data 2 1 11 6 3 2 2 9 4 Data 3 2 3 9 7 1 6 9...

Hi matasapos, The way I understand it, once VF has compiled your functions into a dll, all aspects of Fortran & compiling disappear, and basically Excel/VBA just enters the dll via the entry point that you specified in the original Fortran code i.e.: !DEC$ ATTRIBUTES DLLEXPORT :: GetPI...

Matasapos, See the following thread, this gives you the information you need to call the *.dll from Excel, which is what I needed to do. thread214-465832 Good luck! Drop a reply if you continue to have trouble. That thread, plus setting the VF compiler to Release was all I needed to get it...

Everyone, Thanks for your replies. Tony apologies, I tried it again, after sending that post and it worked fine, however still quite slowly (but better than what I had first of all) :-) However, a star must go to Rob and Combo, as using Robs technique is mega fast and I then combined this...

Tony, Nice idea, but when selecting rows that are visible, it also selects the rows that have been 'hidden' by the filter, so you would in theory delete all the data present. Or have I got the wrong end of the stick? Cheers. BFG

Combo, Thanks for your quick reply - and looks like just what I need. Unfortunately not having much success, most probably due to my lack of understanding!! I've put it into a sub, and when run it comes up with 'Compile error, variable not defined' and points at "firstaddress =" on...

I have an Excel spreadsheet with over 2000 rows of data and need to delete any rows that contain a 'x' in a certain column (approximately 2 in every 7). At the moment am looping through from the end of the data but it is sooooo slooooooooooow :-( Anybody got any better methods? I've switched...