Hi,
Because in my worksheet, I have in column A, the following texts:
Paid
Unpaid
Disputed.

That's why I need a cell.find first.
Thanks,


"Frank Kabel" wrote:

Hi
why do you need this 'find' command first?

--
Regards
Frank Kabel
Frankfurt, Germany
"Jeff" schrieb im Newsbeitrag
...
Thank you,
That's What I wanted, but I need first to do a cell.find in column A
for"paid" then I can do your macro.
Regards,


"Frank Kabel" wrote:

Hi
one way in VBA

dim return_value
return_value=application.vlookup("Total",range("G: H"),2,0)
msgbox return_value

--
Regards
Frank Kabel
Frankfurt, Germany
"Jeff" schrieb im Newsbeitrag
...
Total is always in column G and the value I need always in column H
Thanks,

"Frank Kabel" wrote:

Hi
is your 'Total' label always in column G?

--
Regards
Frank Kabel
Frankfurt, Germany

Jeff wrote:
Hello,

I need help designing a VBA Macro: I have in cell A1 "Paid" in cell
G8
"total" in cell H8 $100.00

What I need is: to cell.find "paid" then to do cell.offset to G8 to
select.copy the value in H8. Is this possible ?
Regards,