Help me5


T

TIMOTHY

Hi all
please help me, i want to copy three columns titleid, type and
royalty
i've recorded the following, my problem is if i know the column name
only not column no. And can you can you minimise the code.
Sub macro4()
range(Selection.selection.end(xldown)).select
Activecell.range("a1:a19, c1:c19, g1:g19").select
Activecell.offset(0,6).range("a1").activate
selection.copy
sheets("columns").select
activesheet.paste
application.cutcopymode=false
end sub
 
Ad

Advertisements

I

isabelle

hi,

What method did you use to name the columns ?

is that names ("titleid, type and royalty") are placed in the cells of line 1 of each column,
(or/and) did you named columns with "Insert, Name, Create"

--
isabelle



Le 2012-09-19 01:23, TIMOTHY a écrit :
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top