The macro recorder will give you the necessary code.


Gord Dibben MS Excel MVP

On Mon, 22 Mar 2010 16:32:01 -0700, VLOOKUP fORMULA
wrote:

Any body help with a macro please........


I have selected two cells from a row from sheet1

Is there any way to copy those cells
go to Sheet2
and insert a blank row in A1
and paste those infor on B3
tks in advance