Search results for query: *

Very simply, how do I call a UserForm from another workbook from within a macro? Many 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

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

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

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

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

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

Tearing my hair our here! I have had this working in various guises but now it is playing up! client definitely exists in the range ClientData but c is not returning a range: Set c = Workbooks("Clients").Worksheets("Clients").Range("ClientData").Find(client...

Am I right in thinking that when you are assigning the rowsource or controlsource of a combobox, you have to use explicit cell references and can't use range names? This works: ComboBox1.RowSource = "'[book1.xls]Sheet1'!$A$1:$A$10" But this doesn't ComboBox1.RowSource =...

Hi All, I want to compare two cell values that will have words in them. Each word will have a number associated with it (in no particular alphabetical order) and the comparison will return a Boolean as to whether cell1 "value" > cell2 "value". I was hoping I could set up an...

Hi all, I have a pivottable like this Class Code %ofColumn SumofMV ----- ---- Fruit Apple 10 100 Pear 10 100 Banana 40 400 Veggie Broccoli 30 300 Courgette 10...

Hi Guys, If you are using VB to manipulate Excel data, is it efficient to load the values into arrays first. I have found that in this particular exercise that I am doing it is much easy to do this rather than continually referencing cells. Also, if you refer to a cell value often, is it more...

Hi, I have designed a Userform and one of the textboxes allows the user to input a specific percentage to attach to a calculation. How can I force the textbox to only accept numbers? Many thanks, Ig

Hi there, What is the code for finding the first row of an autofiltered range? ie if I have data in rows 1 to 1000 and I autofilter it so that the first row shown is 534, I want to return 534 so I can then access data in that row. Many thanks. Ig

Hi,(using XP Home) I was using zoneAlarm (free version) as a firewall but have now added my girlfriend's Mac to my network for ICS. The ICS won't work through ZoneAlarmsbut does work when I turn it off. Can I therefore assume that the XP Internet Connection Firewall is sufficient to protect my...

Having been referred from another forum, can someone give me a clue on a VBA way of doing this. I am aware of the spreadsheet workarounds but want to do it with code. Thanks. ------ Hi all, On a bar chart, I would like to loop through each of the data points and if the value is say <10, then...

Hi all, On a bar chart, I would like to loop through each of the data points and if the value is say <10, then change the colour of the bar to say red. I know how to change the colour in vba by looping through SeriesCollection(1).Points but how do I test the data value it is associated with...

Hi all, I have a pie-chart that references a range that I change dynamically. The question I have is this: Sometimes in my reference table I will have zero values but Excel still plots these and thus clutters the chart. Can you tell Excel to ignore zero values in charts? eg Apples 40...

Hi again, I am using a PivotTable to create some reports (using PivotSelect and Count etc). I actually want to look at the data month by month so I have written this Sub RestrainPivotToMonths(WhichMonth As Integer) On Error Resume Next Windows(&quot;Transactions...