Is it possible to write ERWR on the column of cells this way? I’ve tried write range but all it does is replace the top most cell every iteration. I’m also trying write cell but I have no idea how to make it write down a cell every time
Yes it is may you please share the sample excel
till want length you want to write it 10 row 20 row?
it’s based on the number of forms that’s going to be processed monthly. So I need an iteration based on the number of forms
DataColumnFilling.zip (13.9 KB)
Please find the attached code it will help you if not please let me know