Forum Discussion
Solved
Convert Formulas into Values when cell value changes Mac Excel 2011
Hello, Here's what I want to do: There are several columns linking cells to a data source. These are date-triggered to capture the value on a certain date. upon triggering, the cell value will...
Oh i see what happened.
“I”
Its the wrong type of quote marks. not really sure how that happened.
Replace this line:
For i = start_row To ActiveSheet.Cells(ActiveSheet.Rows.Count, "I").End(xlUp).Row
Hi Philip,
Just to clarify. It is a run-time 1004 error:
Application-defined or object-defined error.
Eric
Oh i see what happened.
“I”
Its the wrong type of quote marks. not really sure how that happened.
Replace this line:
For i = start_row To ActiveSheet.Cells(ActiveSheet.Rows.Count, "I").End(xlUp).Row
- Philip,
That was it! Works beautifully. Thank you so much!
Eric:) super. Glad it worked.