Excelforum - excelforum.com - Excel Help Forum
General Information:
Latest News:
Creating a Macro That will Run Solver Multiple Times 27 Aug 2013 | 02:35 pm
Hello, I am using solver to get the smallest SSE in an intricate model (it involves varying three variables). Unfortunately, it seems that sometimes running the solver more than once yields different...
Web Queries and Formula Help! 27 Aug 2013 | 02:30 pm
Ok, This might take a bit of time to explain but I have looked every where on the web and cant find what I need. I am using Excel 2010. This is for work as a report for me to make life easier. So I...
vba code accordint to the codition the value should display 27 Aug 2013 | 02:26 pm
Hi n thanks i want a vba code like if in a row 3 value is abc and on the cells on (2,1) is correct or incorrect so take the value according to that row with correct or incorrect example Code: ...
Find all in range and add offset value to variable 27 Aug 2013 | 02:24 pm
Hi, I am trying to use the vba find function to search a defined range in (column E) on sheet1 for value x. For each x found, i then want to capture the corresponding value in column(A) of same sheet ...
_change vs _calculate (ByVal) problem 27 Aug 2013 | 02:21 pm
Thanks to some experienced forum users, I've managed to bypass 3 formatting condition limit (excel 2003). However, this works only for values and not for formulas. How do I make this work when there ...
[SOLVED] DoWhileLoop misbehaving 27 Aug 2013 | 01:57 pm
Hello, After a long time away from VBA, im trying to get hold of it again by going through vba for dummies. I encountered following problem: The following Do-While loop is supposed to only exit the ...
Creating and Saving a Workbook - Why So Slow? 27 Aug 2013 | 01:57 pm
Hi, Within a code i create a new workbook and dump some data into it which i then create a pivot table from with that same workbook and then save it all within the same code but the saving part of it...
Adding 2 products 27 Aug 2013 | 01:51 pm
HI All, Can someone tell me how I would or even could add 2 products to the below formula. I wish to include "Electricity" and one other. =SUMPRODUCT(--(Expenses!A1:A590>=DATE(2013,4,6)),--(Expenses...
Using VBA to automate a CMS scriipt - adding more data to bottom of sheet 27 Aug 2013 | 01:50 pm
Hi All, After scouring the internet I have a macro set-up that will automatically run a report on Avaya CMS and save this to a directory with yesterday's date as the file name - this will be setup to...
How do I write a Macro that creates multiple plots? 27 Aug 2013 | 01:49 pm
I have a sheet like this (with up to 20 different labels): Code: X Y Label 0.1 90 A 0.2 80 A 0.3 70 A 0.4 60 A 0.1 8...
