How to solve this Write Range error : Cannot write to the target range because it has hidden rows. Remove any filters or unhide rows and try again?


ExcelWriteRange throws exception if there is hidden column or row, as the specification of Excel activities package 2.8.5 or above.

So, downgrade Excel activities package to 2.8.4 or lower might resolve this issue.

Or can you try to write range to another sheet, then copy it to the target area using other activity?