Ismael
02-23-2005, 08:41 AM
Hi again to you guys,
I'm starting now with VBA, so my doubt can be very simple.
I Have made a code of an IF then ElseIf.... (you can see the code in the attach file)
But I only refer to one cell, as you can see in the code I said that if B4="TP" then return N4 = A4, but now I want to this:
If B4 = "TP" then return N4:Y4 = A4:O4
but I don't now how I can make this reference in VBA.:banghead:
So if any of you guys can give a help I appreciate.
Thanks
Best Regards,
Ismael
I'm starting now with VBA, so my doubt can be very simple.
I Have made a code of an IF then ElseIf.... (you can see the code in the attach file)
But I only refer to one cell, as you can see in the code I said that if B4="TP" then return N4 = A4, but now I want to this:
If B4 = "TP" then return N4:Y4 = A4:O4
but I don't now how I can make this reference in VBA.:banghead:
So if any of you guys can give a help I appreciate.
Thanks
Best Regards,
Ismael