Macro

[Benot_Cambier]

I an writing a macro.I have 2 tables A and B with data.I want to transcribe a range from table A to the first empty range ( under other ranges with data ).

What formule should I use for this ? How to transcribe in the macro ?

Thanks