Looks like you are not using the proper type of the expected data.

Clipboard.SetText(WorkSheetObj.Range("A6:A9"))

Or such