I am trying to append range to an excel doc. but I face this issue, Append Range: Cannot write to the target range because it has hidden rows. Remove any filters or unhide rows and try again.
I am most certain that there are no hidden rows, why is this happening?
Please try to perform the same for empty excel file and you will see if it will work. If yes then there must be something wrong with your current file.
If possible, share us the excel file…
let me have a look at it!!
Not only should there be no hidden rows, there should be no hidden columns either. All should be unhide.