Actualités Tests & Guides Bons Plans

GTA 6 iPhone 17 Copilot Switch 2 Temu ChatGPT Tesla

OVH Cloud

VBA

2 réponses

missk1902

09/06/2006 à 07:30

Hi ,

Pls help with the below VBA query. I have two columns (A & B) in excel

A B
XXXX 111
111
111
YYYY 222
222
222
ZZZZ 333
333
333

I need to write a macro that will copy XXXX until it reaches YYYY, copy
YYYY unit it reaches ZZZZ and so on.

2 réponses

banjo

09/06/2006 à 08:46

http://www.microsoft.com/office/community/en-us/default.mspx?dg=microsoft.public.excel.programming&lang=en&cr=US

Hi ,

Pls help with the below VBA query. I have two columns (A & B) in excel

A B
XXXX 111
111
111
YYYY 222
222
222
ZZZZ 333
333
333

I need to write a macro that will copy XXXX until it reaches YYYY, copy
YYYY unit it reaches ZZZZ and so on.

JB

09/06/2006 à 09:59

[B1].CurrentRegion.SpecialCells(xlCellTypeBlanks).FormulaR1C1 =
"=R[-1]C"
Range("A1", [A1].End(xlDown)).Value = Range("A1",
[A1].End(xlDown)).Value

Cordialy JB

Hi ,

Pls help with the below VBA query. I have two columns (A & B) in excel

A B
XXXX 111
111
111
YYYY 222
222
222
ZZZZ 333
333
333

I need to write a macro that will copy XXXX until it reaches YYYY, copy
YYYY unit it reaches ZZZZ and so on.