Forum

It depends - what do you want to trigger the code?

Essentially the code would be something like: sub AddCommentsToOperations() application.screenupdating = false dim myTable as listobject s...

Option Explicit is your friend. 😉

Your input variable is called SpMorTblName, not SpMortTblName

One way is to create a new column that is the same day for each month (eg first of the month) then group on that to get the max date for each month, t...

Yes, that's possible (most things are!) though I would probably use a listbox rather than multiple comboboxes. I suspect that should be posted as a di...

Have a look at Ron's code here: If you prefer to have the range as part of the message body, then have a look at this one instead:

Change the ShowSelSheets code in Module1 to: Sub ShowSelSheets() Dim ws As Worksheet Dim strType As String strType = Worksheets("Menu...

You could also use: =DATE(A1,1,B1)

It doesn't look like you really need a pivot table per se - perhaps you could use Power Query to just group the data and output a table that you can s...

I think you are out of luck then until such times as it is released more generally (I think it's Insider only currently).

I'm sure there is a fancier way, but you could use a brute-force approach: -add one calculated column for each value column that check if the last ...

If you have BYROW available to you, you could use: =BYROW(A3#,LAMBDA(a,(INDEX(STOCKHISTORY(a,EOMONTH(TODAY(),-4)-1,,2,0),1,2)-INDEX(STOCKHISTORY(a...

The samples provided don't actually have any matches, so it's hard to say why your formula isn't working with your real data, other than that presumab...

Image controls do not have scrollbars. I suggest you use a listbox or similar instead.