Error when writing to Excel .xlsm

[benjamin-gullett]

I am trying to write to a .xlsm workbook starting at a specific row to allow for my header to remain unchanged.  When there is no data in the range, then it runs fine.  However, if I try and run it again I get : Output Data (107) Error: Encountered existing data beyond the specified range.

[mmenth]

Hey @benjamin-gullett,

In your example you have the sheet name and then '$A3:E3', when I think you just need to have '$A3' only. 

Best,

mmenth

[benjamin-gullett]

@mmenth So that worked, but upon opening the file I get the following error.  It looks like whatever it is doing is corrupting the file.

I also need this data to be removed and updated based on changes by the user earlier in the workflow, so by starting at just A3, will that remove all of the data and replace with new data.  That is to say, if I have 200 rows, but the user makes updates and now I only have 30 rows, will it get rid of the 200 and write the 30?

[skulbeth]

This comment saved my brain from exploding. Much appreciated. Simple fix, but one I had looked over for days.