Forum

Technically, for an xlsx file your extended properties should have Excel 12.0 Xml rather than just Excel 12.0, but that wouldn't explain this issue. I...

Not with the current setup because you can't have multiple hyperlinks in one cell. You'd have to separate the results into multiple cells, then hyperl...

Ahh, I had overlooked the fact that your month header cells are also dates (the first of each month) so it is matching those if you use the first of a...

Try the attached version.

There are quite a few issues with that code, not least the fact that you can't use text like vbRed or rgb(153,40,10) in a cell as VBA code. I suggest ...

Excel has two types of checkbox and you are using activex ones (best avoided if you can) so you need: Dim TBarray(1 To 10) As MSForms.CheckBox ...

FYI, the only thing wrong with your initial code (assuming it's inside a With block) was that you were missing some spaces: .Range(4 & ":" &...

Thanks, though I can't claim credit. (unfortunately I've forgotten where I first came across that trick or I'd give proper attribution)

Just as an alternative, you can split the two columns into lists and make a table out of them, then expand that table - see attached sample.

I'm not sure how it would be too much work - the query does it all? See attached demo - I used a pivot table for the output but you could also make it...

Hi Alan, I think you have to use the Account column as the original post only had the totals where the Account column equals the Description column...

Try adding oCht.Activate before the Paste line.

Your initial sample suggests you don't care about which year it is, just the month name - is that correct? I think it's probably simplest just to g...

Been there, done that. 🙂 Very easy to get fixated on a specific path...

Isn't it just: =AVERAGEIF($A$1:$A$60,"<="&SMALL($A$1:$A$60,10))