Macro

%3CLINGO-SUB%20id%3D%22lingo-sub-2232701%22%20slang%3D%22fr-FR%22%3EMacro%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2232701%22%20slang%3D%22fr-FR%22%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EI%20an%20writing%20a%20macro.I%20have%202%20tables%20A%20and%20B%20with%20data.I%20want%20to%20transcribe%20a%20range%20from%20table%20A%20to%20the%20first%20empty%20range%20(under%20other%20ranges%20with%20data).%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EWhat%20formula%20should%20I%20use%20for%20this%3F%20How%20to%20transcribe%20in%20the%20macro%3F%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EThanks%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2232701%22%20slang%3D%22fr-FR%22%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

 

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

0 Replies