I am looking to copy the last cell with value in a column (it is a formula that returns a value). The only problem is that after the last value in a specific column, there are more formulas that return a blank value.

When I use this code :

```
LastRow = Cells(Rows.Count, "C").End(xlUp).Row
Cells(LastRow, "C").Copy

```

it copies the last cell that contains a formula so it copies a blank cell.. I want it to copy the last cell that shows a value.

Thanks for the help!