How to fix an error occurring within this VBA function? (ERR91: Obj/With Variable Not Set)

Hi All,

Not sure if this falls in the Word or Excel VBA bucket (I think Excel?). I've been trying to stitch together a Word VBA Script that takes all the Word comments and puts them into a new Excel spreadsheet, then formats the Excel spreadsheet.

However the "Excel" portion of the code seems to fail after every "other" run. Specifically the error occurs when trying to Left-Align Column C. The error that occurs is "Error 91 - Object variable or With block variable not set". The error happens every 2 runs.

Would anyone know how to fix the Error that occurs below, please? Thanks so much in advance!
(The offending/highlighted line below is: ActiveSheet.Columns("C").HorizontalAlignment = xlHAlignLeft )

Please Login or Register  to view this content.

Thanks so much,
JMC

Is there a highlighted code line when this happens?

The highlighted/offending line is: ActiveSheet.Columns("C").HorizontalAlignment = xlHAlignLeft .

Thx in advance if you or anyone can figure this out!

Have you tried removing the 'ActiveSheet' in front of that line?
The referring should work from the With block doesn't it?

Please Login or Register  to view this content.