How can I detect a cell value in VBA if the cell is text? I want to set
an if statement based on the whether or not cell B7 equals USA.

So if cell B7 = "USA" then copy paste B4, B5, B6 to 1A, 2B, 4B,

If B7< "USA" then copy paste B4, B5, B6, B7 to 1A, 2B, 3B, 4B.

I'm new to programming but have made macros using macro record as well
as modifying some of the macros from examples on the internet. I can’t
seem to find the appropriate functions in VBA help or figure ot enough
from the examples on the site to accomplish what I want. Just a point
in the right direction would be greatly appreciated.

:: Description of what I'm trying to do ::
I have numerous invoices imported from .csv files in excel documents. I
would like to take the billing name shipping name etc and put them all
on one row. Unfortunately since the invoice is saved from a webpage the
Address 2 Field is dynamic I need to detect what kind of invoice it is
to copy the fields. All of our invoices have USA after the city, ST,
Zip cell. So by determining which cell USA is in I can copy paste the
appropriate cells into my row.

Thanks for any help or guidance.

Scott


--
Djmask
------------------------------------------------------------------------
Djmask's Profile: http://www.excelforum.com/member.php...o&userid=24414
View this thread: http://www.excelforum.com/showthread...hreadid=397433