Context: I work inventory at a rebar fab company. I have this report that uses a userform to make tables that show the loads the mill has ready to be picked up. Then this compares these to what we have ordered for the specific cycle (to make sure we get everything we ordered). Now I am trying to have it show what loads are left to be picked up at the mill, so I can convert that data into tons and factor it into our inventory.
The roadblock I am running into is with this equation.
When the userform creates the specific table, there is a "Date" cell next to each pickup number. When a load is picked up I put the date it was received. RemAtMill is the range of these date cells. All I am trying to do here is get the count of each cell in this range that is not blank. But whenever I run the userform and everything is said and done, instead of inserting this formula into the proper cell, I get the text "True". and for the life of me I cant figure out why I get "true" instead of a formula. I am not that experienced in VBA but I have tried a couple of different things and get the same result
The roadblock I am running into is with this equation.
Code:
ActiveCell.Formula = "=COUNTIF(" & RemAtMill.Address & "," <> "&"")"When the userform creates the specific table, there is a "Date" cell next to each pickup number. When a load is picked up I put the date it was received. RemAtMill is the range of these date cells. All I am trying to do here is get the count of each cell in this range that is not blank. But whenever I run the userform and everything is said and done, instead of inserting this formula into the proper cell, I get the text "True". and for the life of me I cant figure out why I get "true" instead of a formula. I am not that experienced in VBA but I have tried a couple of different things and get the same result
