breynolds0431
Active Member
- Joined
- Feb 15, 2013
- Messages
- 303
- Office Version
- 365
- 2016
- Platform
- Windows
I currently have a macro that will ensure column A has a formula inserted as long as the corresponding cell in column C is not blank. It will do this by going down column C until it hits a blank cell and add the formula to all rows up to that point. But, what I fear is that there might be a blank cell in column C on error and the code will prematurely stop at that row. What I'm hoping is that there's an easy way for the code to continue if the next row (or maybe check the next 5 rows) is not blank and continue with the formulas in column A.