Search results for query: *

Thanks all. Got it taken care of. I was having problems at first assigning the formats to variables, but it's working now.

I've got the actual program shifting multiple sets of data on multiple pages, as well as series collections in graphs. Originally it wasn't a problem until I added the different cell formats based on different conditions. I could re-write it using the native sort, which I suspect I'll have to...

I searched and couldn't find anything with regards to formatting in Excel, but if I have a simple bubble sort: If Cell1 > Cell2 Temp = Cell1 Cell1 = Cell2 Cell2 = Temp End If Is there any way to shift over the cell formatting, specifically both background color and font color...

It's a template that allows the user to add sheets that are properly formatted. Every time the program is run on one of those sheets, it analyzes the data and throws certain parts into various graphs. File size was apparently an issue, so I had to delete all the preset source ranges and...

Excellent. Thank you! It was the order that was causing the error.

All right, obviously I'm missing something. I understand that the source data can't read from a worksheet that doesn't exist. And when a worksheet is created, even with the same name, that the chart doesn't automatically update. But what I don't understand is why, if the Series STILL exists...

But the series still remains, and should still be able to be selected and modified using the Series Collection. The code redefines the Series parameters every time the program is run. Even if the sheet is deleted, and the name becomes #REF in the Source Data, is it not still counted as a...

ActiveChart.SeriesCollection(Count).Name = Name ActiveChart.SeriesCollection(Count).XValues = "='" & Name & "'!R6C4:R" & Total + 5 & "C4" ActiveChart.SeriesCollection(Count).Values = "='" & Name & "'!R6C3:R" & Total + 5 & "C3" It always errors on the .Name line. If I change just the...

I did. For example. Run it the first time, Count = 5 so the 5th series name will change. Delete the sheet, add a sheet in the same location. Change the name to the same name. Run the program again. Count = 5 but it errors. I type in SeriesCollection(5), still errors. Tried 4 and 6, both...

Yeah, plenty of series in the graph. 27, actually. And it has no problem working the first time around, the name changes appropriately. But if sheets get deleted and replaced in the same location, it won't recognize the proper series collection location. It will work at places like (Count -...

Having issues getting the program to recognize the series collection name for a graph: Count = 1 For Each wSheet In Worksheets If wSheet.Name <> ActiveSheet.Name Then Count = Count + 1 ElseIf wSheet.Name = ActiveSheet.Name Then Exit For End If Next wSheet...