How to paste data in macro enable .xlsm as its giving error : Cannot write to the target range because it has hidden rows. Remove any filters or unhide rows and try again

Hi i have an macro enable excel that has multiple sheets in one of the sheet i need to update the data from a2 as its has headers already in it but getting error while using write range : Cannot write to the target range because it has hidden rows. Remove any filters or unhide rows and try again

Hi!

can we use write range from workbook instead of write range from excel.

Reference: Write range does not work if there are hidden columns - #7 by Yoichi

this will work in your case

Regards,
NaNI

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.