Simple question today for you; me? Not so simple.
So I have 1 workbook open and I am trying to work in between the different sheets.
This little bit of code has me tricked up; this code is in a larger piece of code so we need not worry about what is ahead or behind it, I just can't debug this thing.
Worksheets("sheets2").range(target.address).offset(0,15).value = "21"
So I am on one sheet and want to make the offset cell = 21.
The sheet name where I want the 21 to go to is called "test5" and is but is actually "sheet2" so I don't know if that matters.
Other than that my excel says I need to debug this.