rng.value

Hi Guys, I have the following code to add a comment each time a cell value changes, however if I change the Range to "N25" everything works perfectly, but if I want to have the code to cover all rows in column "N" I don't get any comment appear when the value changes. Private Sub...

Hi, I need to get the below to start from A2 rather than A1. I think i need to Offset the row but for the life of me cannot get this to work. copied the part of the VBA where i believe this needs to be added. If someone could help that would be great et wkb = appExcel.ActiveWorkbook Set...

I've been idling a dull afternoon away tidying up some VBA that works on ranges using the Evaluate function. More out of curiosity than anything else. I'm keen to understand it, I once came across a piece of horrible spaghetti code that used [Sum(Indirect(formula))] and I just gave up at that...

Hi Guys, I have a for loop which is as follows. 'Do something with all the data between C27 and c37 For Each rng In Range("C27:C37") 'if there is data in the cell then If Not IsEmpty(rng) Then 'List the DDI and then plus one until all numbers are complete. For x...

Hello All, I am trying to write a simple code to look at a value then find that value in a row of values and if another cell says YES then add one to the YES column and if not then add to the no column. The problem keeps giving me an error and I can't figure it out. Attached I have put an...