Search results for query: *

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

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

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

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?

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

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?

I can't really remember how to implement a select case. Here is the deal. I have a User Form that has some option buttons on it. I want a different thing to happen depending on which one is selected. It seems that select case is the best way to implement this but I don't know how to detect...

How can I use excel to pull data off the internet. I want to be able to store it in my program and then manipulate it? I'm making a custom Currency Converter.

I need to add a permanent header in rows 1 through 7, how can this be achieved? Also how can I make a hierarchy of cells so that I can expand and collapse rows or columns?