Hi All,
i am extarcting the data and used filter dt, then again writing to same file using Write range workbook and using excel write range as well, but workbook doesn’t write it and excel write range throws error.
Thanks in advance
Hi All,
i am extarcting the data and used filter dt, then again writing to same file using Write range workbook and using excel write range as well, but workbook doesn’t write it and excel write range throws error.
Thanks in advance
i would not be able share it due to security reasons. sorry
Could you share the error message not the screenshot, remove the sensitive information such as file name from the error message
error : [Cannot write to the target range because it has hidden rows. Remove any filters or unhide rows and try again?) when i am using excel write range.
And no error, when using write range workbook, but not writting the data as well
Try unhiding the rows and column and try to execute the same process. If you are not willing to unhide, provide appropriate range in the write range activity