colindex

Hello !!!! I have this code which creates a module based on values put in excel columns. Basically, I have the name of a division on column 2, an actual number of employees on column 3, a calculated need of employees on column 4, and the difference on column 5 which the box changes colors...

Hey all, I added to an Excel file the following module: Function SumByColor(CellColor As Range, rRange As Range) Dim cSum As Long Dim ColIndex As Integer ColIndex = CellColor.Interior.ColorIndex For Each cl In rRange If cl.Interior.ColorIndex = ColIndex Then cSum =...

Hi all, This is for Excel 2013, and here is my code, which has worked before: Public Function SumByColor(CellColor As Range, rRange As Range) ' CellColor is the cell containing they colour type you are searching for ' rRange is the range of cells to add, if the colour matches...

Hi All I had this procedure working perfectly but it suddenly stopped and is not recognising CL as a variable. I have highlighted the CL in blue which is what excel does when it shows "Expected Function or Variable". Could anyone help please? I have remmed out col1 = CL.Interior.ColorIndex as I...

Hi, I created multiple Textboxes in a UserForm2 based on a row and values from a worksheet. When a user modify a value in those boxes the format of number is not kept. I would like to keep the number format when user change the value of some of these textboxes but I really dont know how to...

I have a function that I want to have run using selection change. The code for the function is: Function SumByColor(CellColor As Range, rRange As Range) Dim cSum As Currency Dim ColIndex As Integer ColIndex = CellColor.Interior.ColorIndex For Each cl In rRange If cl.Interior.ColorIndex =...

Hey, Friends; I have this bit of code that I'm working with that looks through my worksheets and copies data from any worksheet that has a numeric name (job number). It fills a 'master' sheet. I'm also run a script to delete these worksheets when the job is complete. Right now to delete...

Hi, I just found an issue concerning the Sumif function. When I enter the ColorIndex as criteria, it gives 0 as result. I tried to enter the formula in many ways, I even setup a ColorIndex function to check if the color index of the cell in criteria is actually the same as for the cells in...