Help with VBE Need to autoselect rows

G

greenfalcon

Hi i need some help what i am trying to do is have a macro autoselect
rows automatically, the first row is chosen by the activecell, so say
had my curser highlight the contents of

C4

the macro autohighlights the row C, it already does this but i als
want it to highlight the contents in Row D

please help me

Range(ActiveCell.Row).Select
Selection.Copy

here is what i have so far how do i edit it to select Row D, yet, if
have contents in row X selected it highlights

Row X
Row
 
F

Frank Kabel

Hi
no need for selection. you could do this selection with:
Activecell.resize(2,1).entirerow.Select

But use
Activecell.resize(2,1).entirerow.copy
instead
 
Top