Search results for query: *

Very simply, how do I call a UserForm from another workbook from within a macro? Many thanks, Ig

Thanks!

Sounds good - how would this change if my data starts in a18 with that row as the header? Thanks. Ig

Hi Guys, Can't seem to use source data properly. Simply put, I copy and paste an matrix of data into an area which already has a pivottable associated with it. If I just do a PT refreshtable then I might miss some new data that is now outside the range (on rows only) so I thought this might...

Hi Guys, Not sure if this is the right place to post this so apologies if it is not! On some websites I get a popup window saying a runtime error has occurred-do you want to debug? This actually stops me clicking on links. Using XP Home. How can I stop this happening? Thanks Ig

Great guys. Used yours Tony. Thanks.

Hi, Got a problem with a For Each loop This is my code: Sub D() Worksheets("DG").Select For Each cell In Worksheets("CDS").Range(Cells(1, 1), Cells(1, 1).End(xlDown)).Cells Unfortunately it bombs out at the For Each line. I have tried different alternatives and it...

Have rewritten the macro. Thanks.

Skip, Like I said, it only gets deleted because I copy over new data, consolidate and then put it back. DPlank, Ideally I want to avoid that because I have several that need replacing and it loops hundreds of times. Will turning off automatic calculation when I'm doing the jiggery-pokery...

Hi, I have a SUMIF formula in a worksheet1 that references a worksheet2. I then run a macro that moves and deletes all sorts of columns but eventually leaves it in exactly the same format it started in albeit with different data. However, the SUMIF formula in ws1 now has #REF errors where it is...

Sounds good. And how whould I ready the strTheName?

Hi, I want to use a generic user form called from several menu items. Basically it allows the user to chose whether the macro should be run on one dataset on another. My question is, obviousy depending which macro called the userform, different follow on calls will be required so - how can I...

CRACKED IT! Inside the code I call another routine and that was triggering the Error routine. Sorry for wasting your time!

It is definitely the first On Error that is messing it up cuz if I disable that, the second On Error works as expected. I am now puling my hair out!

I know which is why I am baffled! Here is the part of code not working: On Error GoTo jump ActiveSheet.PivotTables("PT).PivotSelect _ "I[ALL]", xlDataAndLabel Selection.Copy Destination:=Workbooks("x.xls").Sheets("DS").Range("R1") jump...

I've done that already and no joy!

Hi, I've run into a problem with my error handling. I didn;t realise that using the On Error Goto line statement actually instigated an error handling routine that rendered future error trapping useless. I was using it as a way to jump say three lines of code and carry on execution eg On...

Thanks Skip but not realy what I need. I fear you may have answered my question though in saying you can't filter a pivot. I need to base the exclusion on the sum of the data itmes to know whether two items have cancelled each other out (ie sum = 0). :(

Hi, Can you hide data items on a pivot table that meet a certain criteria? I know about hiding PivotItems but I am looking to hide all entries that have a Sum of Value = 0. Any way to do this? TIA. Ig

Sorted it by changing how the for each loop referenced the selection.