Macro to change formulas to values

[kishoremcp]

Hi,

I want to update some cells based on daily basis linked with dates.
I have a formula which will do that.

What I want is a macro which will change those cells to paste special values which has a value and keep the formulas as it is if the cell is blank (I mean no values).

Is it possible.

The range what I a looking is only for
rows 2,6,7,9,14

The remaining rows should not effect with the macro.

[kishoremcp]

can somebody edit this and give it for my requirement.

Please Login or Register  to view this content.

[Special-K]

This seems to work

Converts all non blank cells in rows 2,6,7,9 and 14 to values

Please Login or Register  to view this content.

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

G would be the last column with data

[kishoremcp]

Hi JOHN H. DAVIS,

The range is not columns, it is rows.

[kishoremcp]

Hi Special-K,

Not converting non blank rows to values. Still I can see the formula/function even after running the macro.

[JOHN H. DAVIS]

Hi JOHN H. DAVIS,

The range is not columns, it is rows.

The macro is operating on the rows you specified. You only need to change Column G in the macro to the last used Column in your spreadsheet.

[Andy Pope]

Please Login or Register  to view this content.

Edit: having re read the posts in this thread I not sure whether the code will do what you want.
Try posting example workbook with before and after appearence to clarify what you deem to be blank/formula/empty cell