Showing actual formula in next cell of selection.
Posted on 2012-08-14
How would I write the code that will copy the actual formula of a selection into adjacent cells or the next cells to the right of a formula result. Right now, I have to place a ' in the cell, manually copy the formula, and then paste it into the next cell. There could just be one or a selection of 10, but they will all be placed into the next cell. I will also change the color of the formula, but I can add that to the end of the Sub.
C D E F
Name 1 Name 2 Concatenated Text Formula
Alan Jones AlanJones =CONCATENATE(C6,D6)