Prev: User Form Date Field disappeared!
Next: How to set cell validation in excel using name range?
From: Jacob Skaria on 22 Mar 2010 01:29
As Bernie mentioned you dont need to select to copy. You can copy without
selecting the cell

ActiveCell.Offset(1, 0).Copy

--
Jacob


"H. Nissen" wrote:

>
> Hi, This form works, thx: '
> ActiveCell.Offset(1, 0).Select
> Selection.Copy
>
> I have to use it to copy values from a excell sheet into another
> application. With this macro, I do not have to mark and copy every 1.240
> cpr's manually :)
>
> But thx for the help to make the macro.
>
> Mvh Hans
>
> "Bernie Deitrick" skrev:
>
> > ActiveCell(2).Select
> >
> > but there is rarely ever any need to select a cell.
> >
> > HTH,
> > Bernie
> > MS Excel MVP
> >
> >
> > "H. Nissen" <HNissen(a)discussions.microsoft.com> wrote in message
> > news:75E2E7C1-33A6-4E13-98B1-FCBFE1C21638(a)microsoft.com...
> > > Hi, I need to make a macro who can move one cell down from the active cell
> > > and make this cell active. ex: active cell = C1 => new active cell C2.
> > >
> > > I hope some of your hard guys can help me with this problem.
> >
> > .
> >
First  |  Prev  | 
Pages: 1 2
Prev: User Form Date Field disappeared!
Next: How to set cell validation in excel using name range?