Note: I am going to scream. I've typed a response twice now only to accidentally click the back button on my browser and have it erased- so I apologize if any of my response doesn't make sense, as I'm sick of typing it over and over again
1 & 2) I perform an export from MS Project to Excel for my client to review each week. When the export is performed, only columns B-O are present. Therefore, the columns I wish to delete (Baseline Start, Baseline Finish, Resource Names) all line up in columns E, G and J.
3.) Yes, the ID# column is something I'd like for the macro to perform for me. The purpose of this column is so that if there is a change made on the Excel document, I can easily locate it in MS Project. The ID# pertains to the
row# in Project.
4.) Yes, I apologize- I was looking at the ID#'s and confused it with the row. We should be looking at rows 2 and beyond.
*Note: As there are changes made to the timeline itself (tasks added/subtracted) we may not always be dealign with rows 2-264. It could be 2-270, 2-275 etc. as things are altered. Is there a way to just have the macro review the workbook instead of a specific range of rows?
Lastly- I took your last post involving code and implemented it to see if it would work (I changed "For jr = 1 To 264" to be
2 To 264). However, it errors and gets hung up on the following (in red):
Case "Phase"
ce.ThemeColor = xlThemeColorLight2
ce.TintAndShade = 0.799981688894314
The Error says: "Run-time error '438': Object doesn't support the property or method". When I click Debug, the line I highlighted in red font is highlighted in yellow