sees

This has just started to appear as the workbook loads. It continues to load and everything seems fine .. until I try to Hide or Unhide something. Some cols are ok and some bring up the error again. Is there anything I can do to fix it ?

Hi I have the following code to open the workbook and next empty cell . Private Sub Workbook_Open() Dim ws As Worksheet Set ws = ActiveWorkbook.Sheets("2019_20") ws.Cells(ws.Rows.Count, 1).End(xlUp).Offset(1, 1).Select End Sub The problem is that the cells are formated and have data...

Good morning. I have the below information and I am trying to find a formula to complete column U. Cell B1 and B2 play a role. Basically, I would like the formulas in U5:U7 to look at the period between the effective date (column B) through the min of either the Current Month end (cell B1)...

Christ, me again, same topic. Have a look at this: If Cells(ActiveCell.Row, "C").Value = tnam And Left(Cells(ActiveCell.Row, "A").Value, 6) <> tno And InStr(1, Cells(ActiveCell.Row, "K").Value, pup) > 0 Then The left bit is giving me no end of grief. So the fabled "tno" variable is "702228"...

I put this formula in my spreadsheet to help put "pass" or "passes" according to the number on the cell I chose to use. here is the formula...

Greetings - I am trying to calculate the difference in times, using military time. For example: F2 I have entered 16:30 (have a formula entered 00\:00 so I can type in 1630 and it will auto change it to 16:30). H2 I have entered 21:00 (with same formula as F2 for easy entry). J2 I am...

Hi Once I concatenate two dates into one in a cell, how do I then use that cell in a range in a function such as SUMIF, every time I concatenate, the value of the SUMIF function becomes zero, I'm assume its becuase it sees the formulea and not the value, i've tried to format the cell, but it...

I can't figure this one out here is what I need, So in one workbook I need a cell you go look at another workbook in a list if it sees the value NO (which there will be multiple) then I need it to copy the values of cells to the left of it but I need this to happen on each instance it sees the...