if then

[isacp]

if cell contains xx then
can you help me with the wording of this code?

 

[erik.van.geit]

isacp,

It seems to me that it will be better for you to take a deep breath (perhaps go for a little walk) and then concentrate.

You seem to like the "Left" option
example : If Left(Range("A1"), 2) = "O.D."
then your code ...
don't use "item" since it is a "reserved term" in VBA
(you see that because it's getting un uppercase automatically)
let's use "cell" instead
I've inserted a messagebox so you can see what happens

open a new workbook
put in some testdata
paul steven jack Sting
select those data
run this macro

For Each cell In Selection
MsgBox Left(cell, 2)
If Left(cell, 2) = "st" Then cell.Offset(0, 5) = "st"
Next cell

you see?

regards,
Erik

 

[isacp]

thnak you eric
very much
now normally when i use a for each i use item in selection
what would be the difference if i use item or cell?
againn thanx for ur patients

 

[isacp]

i just added it to an old macro it works great
thank you again!!!!!!!!!!!!!!!

 

[erik.van.geit]

You're welcome!

About "Item" (or "Name", "Time", ...)
click in that word within your code and press F1
the Help will appear on that item
sometimes this specific word is needed by VBA itself, that's why we don't use it

test this:
type: name = "excel"
pressing ENTER it will change in Name = "excel"

you can do the same with item, ...

you see ?

regards,
Erik