Forum

Hi Robert, try this: With ActiveSheet.ChartObjects(1).Chart.SeriesCollection(1).Points For Each Rc In Range("C2:C" & f) If Rc <> "...

Hi Carl, I suggest: Power Query, if data needs to be reorganized (usually it does, in order to get a specific report, you need to design the dat...

Hi Matthew, When you press Show Selected, you do know the row number from the worksheet, you just have to pass it to the other form. You can do ...

Hi Velouria, just a minor correction: As Catalin said earlier, those two properties belong to the slicer, so they need to be in the With theSl...

There is nothing indicating what chart type it is you are using: is it a normal chart? is it a pivot chart? Only a pivot chart does not keep format...

Hi Shawn, .CrossFilterType applies to a SlicerCache object, NOT to a Slicer object.

Hi Shawn, The slicer does have a NumberOfColumns property: The problem is that you're working with a Shape object, not with a Slicer object:...

Hi Sherry, Instead of SaveAs, use SaveCopyAs, will leave the current workbook intact.

Hi Shawn, It would be a complex code. The easiest alternative is to save the chart as a template, right click the chart and select Save As Templ...

Hi Cesar, Why bother to build a date picker when you can use existing solutions? See this one:

Hi Erik, There is no such thing as combining data in data model, in data model there will be individual tables and you can create relationships bet...

If you combine the files with the solution described in the link, you will get data like this: Isn't that what you want? You said that you want...

Hi Erik, Try this solution:

Hi Erik, It's not clear what you want to do: you want to combine all source files, or to add each source file as a different table in the data m...

Hi Mandeep, First I think you are referring to rows as columns and to columns as rows (row E, row F are columns not rows), that makes it...