insert comment

I will call these ranges 'builds.' There are 2 builds in this code below, and I need to extend it to 25. I have written the code to make it work for 25, but it's so long, so it needs to be optimised. As you can see, the ranges will always be the same, apart from the last build, which are...

THIS CODE WORKS GREAT BUT WHEN USING OTHER CELLS IT BUGS ALSO ITS RATHER LONG :( THANK YOU INADVANCE. Private Sub Worksheet_Change(ByVal Target As Range) ' Check if the change occurred in cell B6 or B22 or B38 or B54 If Target.Address = "$B$6" Or Target.Address = "$B$22" Or...

insert comment field - how to reset the default font, etc. the 'insert comment' field defaults to a. font size = 9 b. bold how do I reset the default to something that I prefer?

Hi all, I've had a stab at this myself by recording a macro and then attempting the tweaks - but cant seem to get it working. Okay so here it goes.... I'd like to create a marco which will automatically insert a comment into a column of cells. The cells will contain data (part numbers)...

Hello, I am trying to insert a comment on data-validated cells in a column through VBA. There are multiple possible values in the range and each has their own conditional comment. Eg,, if cell value = X, insert comment X. If cell value = Y, insert comment Y. I've been searching the boards and...