are the apostrophe's what is meant by 'tags' when posting code? I want to make sure I submit a request for assistance accurately... But, what I got is, I need to count the number of cells populated across a range, but not the adjacent cell if it's populated... hard to explain.
so, range of cells: c6, c7, c8, c9, c10, c11, c12, c13, c14
8 4 8 8 4 8
would only count as 3, since the adjacent cell has a value in it. Does that make sense? It is to track occurrences regarding absences; the frequency a technician calls in sick.
', Range("C6:NE6").Select
', Range("NG6").Activate
', ActiveCell.FormulaR1C1 = "=COUNT(RC[-368]:RC[-2])"
Thanks in advance with any assistance you are able to provide
Bookmarks