VARIABLE IN EXCEL MACRO
 

Partially, I also expected the answer to give a solution for selecting a
specific part of a block like from a certain cell to 2O lines below and/or 5
colums to the right.

"Stopher" wrote:


Ulrik loves horses wrote:

Try to copy various data from various places to another sheet using Excel
Macro, as this is required on a weekly basis.
However the data which needs copied is always in blocks, but the number of
Lines as well as the number of columns is changing.
Will need to take variable selection criteria in Excel macro as this is
possible in Excel.

Go to a certain cell
select an array using <End Left <End Down functions.
How would you translate these instructions in a Macro?

What about:

' Go to a certain cell
Range ("A1"). select

' Select the current block of data

Selection.CurrentRegion.Select

Does this help any??

VARIABLE IN EXCEL MACRO
 

set rng = Range("B9").Resize(20,5)
msgbox rng.Address
rng.Select

--
Regards,
Tom Ogilvy

"Ulrik loves horses" wrote in
message ...
Partially, I also expected the answer to give a solution for selecting a
specific part of a block like from a certain cell to 2O lines below and/or
5
colums to the right.

"Stopher" wrote:


Ulrik loves horses wrote:

Try to copy various data from various places to another sheet using
Excel
Macro, as this is required on a weekly basis.
However the data which needs copied is always in blocks, but the number
of
Lines as well as the number of columns is changing.
Will need to take variable selection criteria in Excel macro as this is
possible in Excel.

Go to a certain cell
select an array using <End Left <End Down functions.
How would you translate these instructions in a Macro?

What about:

' Go to a certain cell
Range ("A1"). select

' Select the current block of data

Selection.CurrentRegion.Select

Does this help any??

VARIABLE IN EXCEL MACRO
 

Thanks for the info but the 20 and the 5 were just an example . These
variables and will change from day to day, so I really would like to work
also with the end left and sometimes with the end right instructions.


"Tom Ogilvy" wrote:

set rng = Range("B9").Resize(20,5)
msgbox rng.Address
rng.Select

--
Regards,
Tom Ogilvy

"Ulrik loves horses" wrote in
message ...
Partially, I also expected the answer to give a solution for selecting a
specific part of a block like from a certain cell to 2O lines below and/or
5
colums to the right.

"Stopher" wrote:


Ulrik loves horses wrote:

Try to copy various data from various places to another sheet using
Excel
Macro, as this is required on a weekly basis.
However the data which needs copied is always in blocks, but the number
of
Lines as well as the number of columns is changing.
Will need to take variable selection criteria in Excel macro as this is
possible in Excel.

Go to a certain cell
select an array using <End Left <End Down functions.
How would you translate these instructions in a Macro?

What about:

' Go to a certain cell
Range ("A1"). select

' Select the current block of data

Selection.CurrentRegion.Select

Does this help any??

VARIABLE IN EXCEL MACRO
 

If you in the upper right corner of your data then:

range(activecell.End(xltoLeft).End(xldown),activec ell).Select


--
Regards,
Tom Ogilvy



"Ulrik loves horses" wrote in
message ...
Thanks for the info but the 20 and the 5 were just an example . These
variables and will change from day to day, so I really would like to work
also with the end left and sometimes with the end right instructions.


"Tom Ogilvy" wrote:

set rng = Range("B9").Resize(20,5)
msgbox rng.Address
rng.Select

--
Regards,
Tom Ogilvy

"Ulrik loves horses" wrote
in
message ...
Partially, I also expected the answer to give a solution for selecting
a
specific part of a block like from a certain cell to 2O lines below
and/or
5
colums to the right.

"Stopher" wrote:


Ulrik loves horses wrote:

Try to copy various data from various places to another sheet using
Excel
Macro, as this is required on a weekly basis.
However the data which needs copied is always in blocks, but the
number
of
Lines as well as the number of columns is changing.
Will need to take variable selection criteria in Excel macro as this
is
possible in Excel.

Go to a certain cell
select an array using <End Left <End Down functions.
How would you translate these instructions in a Macro?

What about:

' Go to a certain cell
Range ("A1"). select

' Select the current block of data

Selection.CurrentRegion.Select

Does this help any??