Hidden rows error on append range

Help
, , ,
1

Hey everyone,

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?

2

Hi @jntrk,
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.

3

If possible, share us the excel file…

let me have a look at it!!

1 Like
4

Not only should there be no hidden rows, there should be no hidden columns either. All should be unhide.

1 Like