Moving down one row using VB

  • Thread starter Thread starter Geoff
  • Start date Start date
G

Geoff

Hello,

I am currently stuck and wondering if anyone can offer a
solution to the following problem:

I am trying to copy the contents of a particular cell
into the cell below it.

The cell contents are non changing but its location in
the workbook various on each report.

So far I have set up a macro to find the cell and copy
its contents. However for the life of me I cannot now
get the macro to simply drop one row and paste the
contents of the copied cell into the cell below.

Any advice would be greatly appreciated.

Thanks


Geoff
 
Thank you that works perfectly.

One last question could you tell me please what is the
reason or significance behind the 'Range("A1")' bit in
the code - should this not cause excel to use cell A1 or
is it that when used in brackets that 'A' is the column
and '1' is the row regardless of where abouts in the
workbook you are?

Thanks

Geoff
 
Back
Top