Target Offset on another work sheet

Hi all,

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.

Any thoughts?

thanks,

BB