Do you want to know the color of the sky where I live?

It's rose colored!



Tom Ogilvy wrote:

i want to put this formula to column F using VBA where the row number
will change accroding to row number

I think it was an imaginative interpretation <g

--
Regards,
Tom Ogilvy

"Dave Peterson" wrote in message
...
I read the original question where that formula would be put in any single
cell
in column F (like F92).

This may have been an imaginative interpretation, though <vbg.

Tom Ogilvy wrote:

Does Dave's formula look simpler to you? <g It doesn't to me
Especially
when:

Range("F7:F100").Formula = _
"=IF(E7=""CB"",A7&(D7*-1),A7&D7)"

should enter the correct formula in cells F7 to F100 (adjust to suite)
and
all you had to do was add a few double quotes.

this might be one of those times when using R1C1 notation doesn't make
the
formula simpler.

Now I will admit that in my approach the formula has to be specifically
written as if it were to be entered in the first cell of the range
(which is
why I started my range at F7), while Dave's doesn't need to be adjusted,
but
in this case, I don't see that as much of a problem.

--
Regards,
Tom Ogilvy

wrote in message
oups.com...
i want to put this formula to column F using VBA where the row number
will change accroding to row number

=IF(E7="CB",A7&(D7*-1),A7&D7)

Hope you all can help me.

regards


--

Dave Peterson

--

Dave Peterson