njtynhj

Desired Output EX I am attempting to code in VBA for the first time and am being challenged with a project. I'm trying to create a looping counter that will search for a value in a column based on two conditions, add one to count and repeat. I need to set up this code to run based on weeks and a value in a separate column. Any input on how to do this and what I may be doing wrong would be greatly appreciated. Thank you. Edit: I am trying count instances of 5 different ranges in a column of cells and sort them by week it occurred. I have a column in an excel sheet that convert dates to week number. so for instance, if a value is greater than 53.33 and occurred twice on the fifth week of the year, the program would populate a cell with 2. By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these p...

Code: Issue: I'm only trying to learn how to autofill a column dynamically. The code is intended to select the start cell(after a formula has been entered within it) and then autofilling to the last row. The last line listed within the code is the line highlighted with the error. Error: Method 'Range' of object '_Global' failed Caveat: The code has been condensed for the question. By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.