.calculation

Hi, Previously I had 1 listbox with the 52 weeks of the year. Listed WK 1 to WK 52. I have change my userform now because the listbox was too long. I now have 2 listboxes. Listbox1 from WK 1 to WK 26. ListBox2 from WK 27 to WK 52. I have the following code that worked when it was just the 1...

Good Day, I am having trouble with an excel formula. I would like for my VBA script to delete all rows where a specified word exists in a specified column. My problem, however, is that the columns can sometimes change so I would like the script to be based on the headers rather than the column...

Hi, Would someone be willing to eyeball my code below and advise why it is failing at the line: ".Offset(1, 0).SpecialCells(xlCellTypeVisible).EntireRow.Delete"? What I find confusing is: 1. There is no sheet protection 2. The table headers are not selected 3. Changing the "Delete" method to...

Hi all, My code below is for a checkbox in a userform. When I load a manager and click the button, it saves a "flight risk" entry to their row in the database. The problem is, when I close and re-open the userform for the same person, the tick disappears even though I already saved them as...

Hello, I need to paste my header row into every blank row on my sheet. The header is at Row 2. Each blank row is spaced 5 rows apart. I've tried several variations of his code, to no success; ActiveSheet.UsedRange.Select Dim i As Long With Application .Calculation = xlCalculationManual...

Hi all, I have found the below macro to remove blank rows in a sheet. I run it, however it does not remove the blank rows (but tells me that it has). I think I need to set the range. I have added a Range called 'Blank_Cells' but I don't know how I add this into the code, can anybody please...

I'm currently using the Excel 2010 version. I'm building a pivot table and am trying to figure out which .Calculation options I should be using based on the example below. For example: ' Set up the data fields With PT.PivotFields("Good") .Orientation = xlDataField...