data.cellsi

Hello, this VBA code will work sometimes, but does not work others. It seems to delete the reference labels & text (Text0 and xLabel0) occasionally when ran (not always). I have confirmed that these values are not found within Worksheets("PoAP (Data)"), so I am unsure why they are...

I am creating a Gantt Chart with certain events (represented by icons). Each row in my table represents one event, and the type is represented by the naming convention (Icon1,Icon2,Icon3...). These names found within the row will match the Name Manager names of the icons already created in the...

I am looking to insert icons based on the category of the entry (not all using that same icon url below). Any ideas on how to combine the Cells(i,n) formula to output the icons? Any other ideas? Sub Macro() 'Part 1 Dim p As Integer p = 3 Do While Worksheets("PoAP (Data)").Cells(p, 2).Value...

I have column D of times that I need to subtract 5 hours from each. I wrote the following code: For i = 2 To LR If IsEmpty(data.Cells(i, 4)) = False Then data.Cells(i, 4) = DateAdd("h", -5, data.Cells(i, 4) End If Next i I wasn't sure if this was the best way or not, but it seemed...