mdo

dim data as variant Data = shB.Range(Cells(9, 1), Cells(LR, 12)).SpecialCells(xlCellTypeVisible) If LR =20, but a hidden row exists at row 12, then the data variant only grabs rows 9-11, not all the way to row 20. What am I doing wrong? Thank you in advance

I'm trying to set up a worksheet change event that creates a checkbox in column 1 if the cell in column 8 changes. I am able to get a checkbox, but I can't get the caption to change. I'm able to do it using this code, but I don't want to do it manually. Thank you in advance for any pointers...

Good Morning and thank you for reading. This forum has been a tremendous help! I am new to VBA and self taught with youtube and these forums, so I apologize if my code is sloppy or poorly written. With that being said, I have a workbook that has our bid sheet. I am trying to create the proposal...