Search results for query: *

I" is a where one part of what I'm summing ends, I acquire it in the step before this with a while loop that finds the first instance of a string. I corrected the problem with the "LColFC", I have another variable that goes there, it was a typo. I am trying to build a chart of Design and...

I'm trying to sum some columns in VBA so I can chart them. I am stuck on how to apply the worksheetfunction method. It's funny because this is probably the easiest thing I have done, but it's the only part I need help with. Here is some ways I was thinking of accomplishing this. For P = 4 To...

Problem Solved, I used the pivottablewizard method to reset the range an then I just refreshed the data. Thanks for the replies.

It's not necessary. I just want to refresh it I suppose. As I said I don't really have any knowledge of the PT object. Could you show me a way of doing this?

I Guess I should have posted more. This code will be modified to find the length of the data I am selecting each time and before it is called the previous pivot table will be deleted, actually everything on the sheet it goes on will be deleted. So Yes I do want to add a pivot table everytime I...

Hello, I'm writing a little piece of code for something I'm doing at work and I'm having trouble with a persistent error. I'm taking data from 5 sheets on a work book, combining it and then creating a pivot table. I have the first part, but the Pivot table is giving me some trouble. I don't...

Correction error is line 3 char 2.

function WriteFile() { var fh = fopen("c:\\MyFile.txt", 3); if(fh!=-1) { var str = "Some text goes here..."; fwrite(fh, str); fclose(fh); } } WriteFile(); I am getting an error that says line 3 char 5 object expected. I'm new to JS I don't know much about FSO...

I have looked at inline frames (iframes) and I don't understand how to use it to get html off of another document, all it does is display content from the same page or an entire website. Maybe example code would help.

I need a way to transfer content between pages. Here is what I want, When I open my homepage I want a js code to go on to a different page of my site and grab some content and then paste it inside a div. I know how to paste something inside a div, I don't know how to grab content from another...

Perfect PHV, thank you.

Hello all, I have a sub that is called upon selection change and I want to keep it that way. My problem is that when I run another sub it activates a sheet and highlights all the cells with formulas in them, so my first sub is called because the selection is changed, I do not want this to...

Is there an easy way to put an entire array into a string. I have an array of numbers and I want to display them to my user in a message box. I don't want to have to convert every value one at a time. Any ideas?

That is exactly what I needed thanks!

I have a sub in a module, it has to be in this module so it can't be located in the sheet I'm operating in. I have a combo box loacated on a sheet. I need to access the values in the combo box from the module. Any Ideas? Can I some how dim the combo box in the module?

I should have done it as a 2D collection from the beginning that makes it alot easier on the loading, and rewrite.

I could do that, I need to read up on the sort feature. I only started programming heavily in the past couple of days. Here is the problem with putting the info back on the sheet. Case "show all" Dim H As Integer 'selecting cell A1...

I have built an array of ranges. Now I want to sort it by the value of one of its columns and then insert it back into the spread sheet. I can't figure out how to sort an array of ranges by cell values though. Any ideas?

Thats a start. But I want to select certain parts of each sheet.

I want to print certain tabs by pressing a button. I used a counter to find where each tab ends and now I'm trying to select the range. How do you select ranges? is it worksheet.select.range? I also don't know the print commands to use do I call the sheet and then print it?