Prev: User Form Date Field disappeared!
Next: How to set cell validation in excel using name range?
From: H. Nissen on 21 Mar 2010 16:40
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.
From: "Bernie Deitrick" deitbe on 21 Mar 2010 17:40
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.

From: FSt1 on 21 Mar 2010 18:03
hi
from you example, i'm having a problem understanding what your are trying to
do.
but..
Activecell.offset(1,0).select

not sure if this helped. post back with more info on what your are doing.

regards
FSt1

"H. Nissen" wrote:

> 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.
From: H. Nissen on 21 Mar 2010 18:31
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 an other
application. With this macro, I do not have to mark and copy every 1240 cpr's
manually :)

But thx for the help to make this macro.

"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.
>
> .
>
From: H. Nissen on 21 Mar 2010 18:36

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.
>
> .
>
 |  Next  |  Last
Pages: 1 2
Prev: User Form Date Field disappeared!
Next: How to set cell validation in excel using name range?