Recent content by lemo

Thanks Minty. Interesting, but I think the ablebits solution applies to single table situations. Once you try to marry two tables of different dimensions, SUMPRODUCT becomes rather unfriendly. Having said that, I nailed the formula. For posterity, if you paste the table above into A1, the...

Hello all, it's been a while since I visited, hope everybody is healthy and in good spirits. I have two tables, Orders and Prices, see below, I'd like to calculate totals for each row in Orders, by multiplying quantity by price, then summing them. Currently I do it by creating another table...

that's pretty impressive, Angelo_81! 2700 lines of code, just in one sub.. love! (of chess). one small suggestion - ability to take a move back. in case you misplace a piece, or if it's a friendly game where you can take back obvious blunders. thanks sauanu and pedrowave, good stuff too. l

Ok, made it work by using ws.Unprotect rng.Copy Destination:=ws.Range("R24:V46") ws.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True instead of With ws .Unprotect .Range("R24:V46") = rng .Protect DrawingObjects:=True, Contents:=True, Scenarios:=True End With...

I stepped through, nothing shows up on the first few sheets where I expect the line .Range("R24:V46") = rng to copy my source range to the destination.

Howdy, it's been a while, hope everyone is doing fine. I have this rather simple code below that runs without errors, but it doesn't actually do what it supposed to do - copy a range of cells from one sheet to other sheets. Nothing is copied for some reason. Could you help please. Thanks in...

got it thanks.. :D

wait, what's that green smiley doing there?! you get the idea...

something like this should work - =COUNTIFS(A$2:A$10,1,D$2:D$10,TRUE)/COUNTIF(A$2:A$10,1)

Yes, looks like I have SP1 for the Office 2013. Btw, Rx_, brace yourself for some grey ugliness, design wise.. It will be, I reckon, a month or more before you get used to it.. and a few other annoying changes, as per usual. But not too bad overall, and there are some interesting new features...

Thanks Rx. Will check on the SPs, I am not sure I got the updates. l

Hello. In Excel 2013, the borders color of the simplest of the PivotTable Styles (found in DESIGN->PivotTable Styles->upper left corner in the grid with all the other styles; it's strangely called 'None') is unfortunately grey. How can I make it black, as it used to be in 2007? I can probably...

But it's true! And the worst thing is I have no idea why. I am relatively good at Excel, less so at Access, and have really no clue what happens when the two communicate with each other. Access rewrote NOT (VarA Is Null AND VarB Is Null) as ((VarA Is Null And VarB Is Null)=False) maybe...

An old thread, but just wanted to add something for posterity. I realized I still had issues even with that #6 solution, NOT (VarA Is Null AND VarB Is Null), not in Access itself, but when I was trying to use the query as a data source for a pivot table in Excel. Somebody suggested this - ...

and another thanks goes to spikepl for educating me on what San Serriffe is.. fun!