That's fine, but can you tell me why this line is in your code?
If all we are checking is the Range D13 and changing it value depending if its blank or "HP-1", how do we effect cell C13?Do Until ActiveCell.Offset(0, -1).Value = ""
That's fine, but can you tell me why this line is in your code?
If all we are checking is the Range D13 and changing it value depending if its blank or "HP-1", how do we effect cell C13?Do Until ActiveCell.Offset(0, -1).Value = ""
Remember To Do the Following....
Use [Code].... [/Code] tags when posting code to the thread.
Mark your thread as Solved if satisfied by using the Thread Tools options.
If posting the same issue to another forum please show the link