What I need is a macro that I can run after data is entered into A1 and B1 and end up with the expected results in C1. The =ROW(INDIRECT(A1&":"&B1)) formula works fine if I run it manually but when I try to record the process into a macro I run into problems. The code that is in the recorded macro seems to be tied to the results of the A1 and B1 values that were used in the macro that was recorded so if I change A1 or B1 I do not get the expected results.