Forum

Do you want it to do every table on the sheet? If so, something like: sub AddCommentsToOperations() application.screenupdating = false d...

Which version of Excel do you have?

Your workbook isn't particularly helpful (to me anyway) as none of the source data is available to have a look at. Could you at least provide an anony...

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 ...