Last seen: May 22, 2025
I don’t really understand. One code adds and formats spark lines while the other only adjusts the location and data range of existing spark lines. It ...
I didn’t say that Chr and ChrW are the same. I said that both expect a number to be passed to them, not a string.
That routine replaces the previous one of the same name. The worksheet code that calls it remains the same. as long as there are spark lines o...
I do like the idea of a sparkling sheet! 😉 If you already have the sparklines in place, then the code can be a lot simpler: Sub UpdatePivo...
IMO you would be better off converting the dates to the 1st of the month so that you can use them as dates in calculations. You can always format the ...
Not a big deal but just so you know: Chr (like ChrW) expects a number, not a string, so by passing strings you're actually making it do unnecessary wo...
You should be able to just wrap another IF: =IF([Amount]<>0,IF(COUNTROWS(FILTER(Table1,[Invoice]=EARLIER([Invoice])&&[Branch]=EA...
Private Sub Button26_Click(sender As Object, e As EventArgs) Handles Button26.Click That is VB.Net code by the way, not VBA.
If I understand correctly, you could use this: =IF(COUNTROWS(FILTER(Table1,[Invoice]=EARLIER([Invoice])&&[Branch]=EARLIER([Branch])&am...
You can also do it with code. Add this to a normal module: Sub UpdatePivotSparklines(pt As PivotTable) With pt Dim sparkRange As Range ...
FYI, cross-posted here:
Also cross-posted here:
Using TEXTBEFORE with the same arguments should return the address up to the STE part.
To strip off everything after the last period, you can use Instrrev: Left$(UserForm1.TextBox1.Text & "", Instrrev(UserForm1.TextBox1.Text,...
You could also use: =TEXT(I2*100,"00:00")+0 with the same [h]:mm formatting