Last seen: May 22, 2025
Why do the users have to have their own individual files, rather than writing to one central file (or database, or List)? It's making everything a lot...
I'd guess that was the Title column, which is a system column. You cannot change its data type, nor can you delete it.
You've got manual formatting applied to some cells (eg a light blue fill on the Jan sheet). You should remove that.
Try something like this: Sub data() Dim ws_Form As Worksheet Set ws_Form = Sheets("Form") Dim ws_Data As Worksheet Set ws_Data = Sheets("Data") Dim...
If you change cells in a Change event, you should always disable events while you do so to avoid recursion: Private Sub Worksheet_Change(ByVal Targ...
Using the IMAGE function is not the same as inserting a picture on a sheet. You cannot select or name the picture as it is a function result, not a sh...
Custom ribbons don't work for hidden normal workbooks (i.e. that don't have the IsAddin property set to True).
Not really, no.
I don't think you can link them. You can copy and paste the image from the sheet to use as the picture fill for a data point, but it's static. You cou...
My suspicion would be that this code is not the cause of the problem. It could only delete the file when you run it, and it will only delete the file ...
I can't see anything wrong with the revised code (though I'm surprised you're saving it locally given what you describe) - if the file failed to save ...
I disagree. It will not work properly in a UDF - Microsoft even states that in the documentation.
OK, there are almost certainly simpler formulas, but I think this works in G15 and copied across and down: =LET(firststart,MAX($B15,G$12),firstend,...
Which version of Excel do you have? It will affect which functions can be used. For the first one, I think this formula in G5 and copied across and...
Hi Hans, It doesn't work properly though. DisplayFormat cannot be reliably used in a UDF - try updating some of the values so they go yellow and yo...