Search results

Thank you so much, Haseeb! Those formulas certainly did the trick. I had originally thought a SUMPRODUCT formula might be the way to go, but I figured I was looking for a COUNT function of some sort. Looks like I need to dig deeper into Chandoo's Formula Forensics to better familiarize myself...

Will this code work? It prevents a user from saving the file under a different file name (although they can save it using the same file name but in a different location). http://www.teachexcel.com/free-excel-macros/m-21,prevent-saving-workbook-under-diff-name.html

Asaf, I'm not certain exactly how this report is supposed to be structured, but I copied your code into a module and worked out all the kinks I could identify. Below is the revised code I came up with. In a few cases, you had an undeclared variable (cursale was declared, but in some places it...

I've been wracking my brain for a few hours now trying to come up with a solution to this problem, so I've broken down and decided to ask my friends at PHD for some advice. I have a report that I compile daily (I pull it from a different report with about 12 times more data than I need). There...

I have an alternate solution to this issue. We use this in my office so that I can make macros available to all users relatively simply. We have a folder on our shared drive whose sole purpose is to house macros. The only file in the folder is (imaginatively enough), Macros.xlsb. Then, we had...

I've revised the macro so that it only places a border on non-blank cells. I hope this is a solution that will work for you. Sub CellBorderNonBlanks() 'Declare Variables Dim lngLastRow As Long, lngLastCol As Long, rngCell As Range 'Determine Last Row and Column With Data lngLastRow =...

Does this work for your purposes? <code> Sub BorderNonBlanks() 'Declare Variables Dim lngLastRow As Long, lngLastCol As Long 'Determine Last Row With Data lngLastRow = ActiveSheet.Cells(Rows.Count, 2).End(xlUp).Row lngLastCol = ActiveSheet.Cells(2, 2).End(xlToRight).Column...

When creating text arrays in VBA, I've found that it can be quite tedious to type every single item in an array, especially if the list is long. So I created this macro which will take a list of values in Column A of the active worksheet and produce an array in Cell C5. You can then copy the...