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.