Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
MACRO: Convert Row Formula to Value
Hello,
I have duplicate formulas through 5000 rows, columns A - F . I would like to convert the row formulas to values if a result in column F is present. is there a simple macro which will a) Find rows with formula b) evaluate if cell within row ( column f ) contains result c) convert row results to values - over view - trying to reduce the EXTREME size of dependent sheet. Many thanks ! Steven / Dallas |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
MACRO: Convert Row Formula to Value
Hi Steven:
Sub sonic() n = Cells(Rows.Count, "F").End(xlUp).Row For i = 1 To n Set r1 = Range("A" & i) Set r2 = Range("F" & i) Set r3 = Range(r1, r2) If IsEmpty(r2.Value) Then Else r3.Copy r1.PasteSpecial Paste:=xlPasteValues End If Next End Sub -- Gary''s Student - gsnu200740 "SteveT" wrote: Hello, I have duplicate formulas through 5000 rows, columns A - F . I would like to convert the row formulas to values if a result in column F is present. is there a simple macro which will a) Find rows with formula b) evaluate if cell within row ( column f ) contains result c) convert row results to values - over view - trying to reduce the EXTREME size of dependent sheet. Many thanks ! Steven / Dallas |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to convert text | Excel Discussion (Misc queries) | |||
writing macro to convert excel to pdf | Excel Discussion (Misc queries) | |||
convert a formula into a macro | Excel Discussion (Misc queries) | |||
Macro to convert Name of worksheet | Setting up and Configuration of Excel | |||
Convert hhhh:mm:ss to hh:mm:ss (macro ?) | Excel Worksheet Functions |