rangev

hello, So far I have this code. but not working for visible cells. Any idea, please! For Each j In Range("A2:FL" & lastRow).SpecialCells(xlCellTypeVisible) ii = j.Row If Rows(ii).EntireRow.Visible = True Then If Range("V") <> "" Or Range("V") <> vbNullString Then _...

Hello, I have developed the following code to compare cell values and color it. I know my code is accessing the sheet every time which makes program slow a for a large number of comparisons. Is anyone have an idea to optimize the code using array OR any other way to run faster than this? Thank...

Good morning, i am trying to get the following code to work, have tried various combinations of if ,or, else, elseif but to no success. I have not copied all the statements , but effectively what i am tying to do is. i column 6 (f)is between 1 an 8 it completes the relevant sum. If greater...

I know that in order to use Sumproduct in VBA I need to have the results set as value. For example, here's a code that I have been using and it works great: With ActiveSheet.Range("P" & LR + 1) .Formula = "=SUMPRODUCT($N$16:N" & LR & ", $P$16:P" & LR & ")/SUM($N$16:N" & LR & ")"...