M
Minitman
Greetings,
I have a cell formula that is damaged each time I run a delete to
remove excess rows before a paste & copy. this formula links to a
cell that is always deleted. So I am trying to repair this formula at
the end of each cycle.
Here is the correct formula:
=IF(A11="Proximates","Click","")
Here is the same formula after the delete:
=IF(#REF!="Proximates","Click","")
I tried to fix this in the code that does the finale copy & paste with
this:
Range("B2").Formula = "=IF(A11=" & Chr(34) & "Proximates" & _
Chr(34) & "," & Chr(34) & "Click" & Chr(34) & "," & Chr(34) _
& " & Chr(34) & ")"
(B2 is where this formula is sitting)
Debug did not like the syntax!!!
Anyone have any ideas, thoughts or suggestions?
Any help is appreciated.
-Minitman
I have a cell formula that is damaged each time I run a delete to
remove excess rows before a paste & copy. this formula links to a
cell that is always deleted. So I am trying to repair this formula at
the end of each cycle.
Here is the correct formula:
=IF(A11="Proximates","Click","")
Here is the same formula after the delete:
=IF(#REF!="Proximates","Click","")
I tried to fix this in the code that does the finale copy & paste with
this:
Range("B2").Formula = "=IF(A11=" & Chr(34) & "Proximates" & _
Chr(34) & "," & Chr(34) & "Click" & Chr(34) & "," & Chr(34) _
& " & Chr(34) & ")"
(B2 is where this formula is sitting)
Debug did not like the syntax!!!
Anyone have any ideas, thoughts or suggestions?
Any help is appreciated.
-Minitman