I've got errornotice for following code:
Cells(ActRow, 41).Value = NewUseVol
I already define ActRow and NewUseVol(=0) (with public)
Would you please suggest any solution to handle this error?
I have a spreadsheet where I retrieve almost 200 lines of data from another program. I have created the following macro that will hide all rows where the value of the cells are 0. The macro works but I think it takes too long. Can you help me speed it up? I have done extensive research on...