Last seen: May 22, 2025
I'm not really clear on what you mean, but perhaps you want the wildcard * which will match any text in the specified field? (Note: it will not match ...
I can't reproduce that. I get a number the first time and then 0 thereafter. What exact code did you use?
If they are the only files in the folder, you could simply process all the files excluding the Summary one using something like = Folder.Files("folder...
I've only got Excel 2010 here so can't actually work with your model, but as a simple solution, couldn't you just create a set based on column items a...
Simple option is to just to duplicate what you do for the first combobox, like this: Private Sub UserForm_Initialize() Dim d As Object, va, i ...
You could use: c.value = vbnullstring which will work with merged cells too.
You can't copy a worksheet from an XML format workbook to an xls, since they have different numbers of rows and columns. You'll have to insert a new s...
If it works from an .xls and not from an .xlsm, I'd guess you are copying to an .xls file? If so, a sheet from an xlsm (or xlsx/xlsb) has more rows an...
Instead of deleting the axes, you could simply hide the lines and make the labels the same colour as the chart area, so it won't resize at all: ...
range("B" & MyDato, "D"). Value is not valid syntax, as you have mixed up Range and Cells syntax. Assuming MyDato is a row number, you would ei...
To do it in code, you can just use: ActiveChart.SetElement msoElementChartTitleCenteredOverlay The same approach should also work manu...
If you don't want a helper column, I'd suggest: B2 =SUMPRODUCT(($J$18:$J$722<$K$18:$K$722)*($G$18:$G$722=$A2)) C2 =IF($B2>0,SUMPRODUCT((...
Assuming it's the only chart on the sheet, you can use this: Sub Copia_Immagine_Chart_Sul_Foglio2() Dim MyChart Worksheets("Foglio1").ChartObject...