How to write in Macro file which has hidden columns in worksheet

I am trying to write data based on column name into Macro file which has hidden column in sheet, I was able to write it properly with the help of excel application scope and write range activity till yesterday but suddenly write activity started giving exception “Write Range: Cannot write to the target range because it has hidden rows. Remove any filters or unhide rows and try again.” Can anyone please help me to find the solution