get cell

I have a column of dates and depending on the date, my conditional format will fill the cell with a specific color. I am trying to count the number of cells with a specific color. I've tried the GET.CELL function (although I may be doing it wrong) to try and return the background color value...

I have a workbook with 5 sheets: "MAIN" where data is entered, and four others - each linked to various cells in "MAIN." There are no calculations done in the links because the data is all text: For example: "=MAIN!B3" What I need to do, however, is get not only the cell's value, but also the...

Hi guys I use this code but I still dont get the first cell in the same column and row 1 see code below: Sub Langauge_Combination() For Each sht In ActiveWorkbook.Worksheets Set Rng = sht.UsedRange Set MyRange = Rng For Each MyCol In MyRange.Columns For Each MyCell In...